Home
Search results “Vba border style”
Excel VBA - Borders
 
04:33
Excel VBA - Borders Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Setting borders in Excel VBA
 
05:27
Programmatically manipulating borders using Excel VBA.
Views: 4364 Mike Colbert
550 Excel VBA formatting , Excel VBA coding, change Font, color, Alignment, Border style  (HINDI)
 
24:49
Log www.iptindia.com Call +91 8826828093, +91 8802579388 Skype ID - AdvExcel1
Views: 121 Ajit kumar Singh
Draw Borders Around Cells using VBA | Excel Tutorial
 
02:49
Buy Me a Coffee? https://www.paypal.me/jiejenn/2 Your donation will help me to make more tutorial videos! Draw Borders Around Cells using VBA There are a lot of Excel books out there but below are the books I personally recommended For beginner Excel users ► Excel 2016 In Depth: http://amzn.to/2tlCWDf ► Excel 2016 Formulas: http://amzn.to/2uDGwcl ► Excel 2016 For Dummies: http://amzn.to/2uy4g0L ► Excel 2016 Formulas and Functions: http://amzn.to/2tlvyYM ► Excel 2016 Bible: http://amzn.to/2tlvPLi For intermediate/advanced Excel users ► Excel 2016 Pivot Table Data Crunching: http://amzn.to/2uybK3V ► Microsoft Excel Data Analysis and Business Modeling: http://amzn.to/2uudf3k ► Excel 2016 Power Programming with VBA: http://amzn.to/2uDZRtS ► Excel 2016 VBA and Macros: http://amzn.to/2uuCTVq Equipment I use for recording ► Blue Yeti USB Microphone: http://amzn.to/2vxs6H3 ► Camtasia 9: http://amzn.to/2tlBNvz If you find this video helpful please give me a like to my video and subsribe to my channel. Thanks!. For any question, please email me at [email protected]
Views: 2124 Jie Jenn
Excel Macro Tutorials - Draw borders using VBA
 
10:40
In this video you'll learn how to play with cell borders using vba and create various applications that require special formatting, graphs that are not there in excel and in various other forms. Please hit Like if you find it useful and do not forget to subscribe for more such updates.
How to create a page border in Excel with VBA
 
03:29
How to create a page border in Excel with VBA Automatically create a page border on any worksheet in Excel. Create a thick border around the edge of the printed page. Code Sub Page_borders() Dim rngBorder As Range Dim lngLastRow As Long Dim lngLastCol As Long Dim fstRow As Long Dim fstCol As Long Dim printRng As Range Set printRng = Range("A1:I46") lngLastRow = printRng.Row + printRng.Rows.Count - 1 lngLastCol = printRng.Column + printRng.Columns.Count - 1 With ActiveSheet fstRow = 1 fstCol = 1 Set rngBorder = .Range(.Cells(fstRow, fstCol), .Cells(lngLastRow, lngLastCol)) rngBorder.BorderAround xlContinuous, xlThick End With End Sub For more help visit my website http://www.easyexcelanswers.com or email me at [email protected] I can customize this Excel application for your exact needs for a fixed price of $50. The work is normally returned within 24hrs. I am able to provide online help on your computer at a reasonable rate. MY videos are all created on Camtasia. http://send.onenetworkdirect.net/z/582993/CD237560/ Follow me on Facebook https://www.facebook.com/easyexcel.answers
Views: 1008 Barb Henderson
Excel 2013 Video 31 Apply Borders with a single VBA code line and the Efficiency of the Macro Record
 
07:28
I have a PHD in Economy, many years of experience in Accounting, Taxes declarations for Individual and Corporations, Balance Sheet Preparation, Financial Analysis, Financial Mathematics, Market Analysis. Im in search of job opportunities in Canada as an Excel Expert and Macro Developper if you are interested email me at this address [email protected]
Views: 5488 ExcelStrategy
USEA Excel Exersice 2 (Add Picture, Border Style, Symbol)
 
22:51
Expected Outcome of This Exercise - You can Marge Cell in Ms. Excel - You can set text Alignment on cell - You can set border Style in Ms. Excel - You can insert Picture - You can insert symbol - You can set Header and Footer in Ms. Excel. - You can make a Schedule Form. by SANG CHUMNO
Views: 101 Computer Teaching
Microsoft Excel Sheet with Gradient Border Style
 
06:30
This video shows how to create a "Web Page Looking" Microsoft Excel Sheet with Gradient Border. This video will show how to merge cells, apply gradient formatting for colors, hiding rows and setting the sheet to appear to have a fixed width and height. This can be completed in Excel 2007, Excel 2010 and Excel 2013.
Views: 4506 Alex C
Automatic borders when you paste with VBA in Excel
 
01:18
Automatic borders when you paste with VBA in Excel Autofit columns in excel. Put borders around data that you are pasting in Excel code Sub copywithborders() Dim x As Integer Dim account, QTY, Weight As String x = 2 For x = 2 To 11 account = Sheet1.Cells(x, 1).Value QTY = Sheet1.Cells(x, 2).Value Weight = Sheet1.Cells(x, 3).Value Worksheets("sheet2").Select erow = Sheet2.Cells(1, 1).CurrentRegion.Rows.Count + 1 ActiveSheet.Cells(erow, 1) = account ActiveSheet.Cells(erow, 2) = QTY ActiveSheet.Cells(erow, 3) = Weight Columns("A:A").EntireColumn.AutoFit Columns("B:B").EntireColumn.AutoFit Columns("C:C").EntireColumn.AutoFit Set Rng = Range(Cells(1, 1), Cells(erow, 3)) With Rng.Borders .LineStyle = xlContinuous .Color = vbBlack .Weight = xlThin End With Next End Sub For more help visit my website http://www.easyexcelanswers.com or email me at [email protected] I can customize this Excel application for your exact needs for a fixed price of $50. The work is normally returned within 24hrs. I am able to provide online help on your computer at a reasonable rate. MY videos are all created on Camtasia. http://send.onenetworkdirect.net/z/582993/CD237560/ Follow me on Facebook https://www.facebook.com/easyexcel.answers
Views: 368 Barb Henderson
Creating Borders around Cells, Columns and Rows MS Excel 2016
 
04:00
Give your Worksheets a more compelling style by adding some subtle borders around Cells Columns and Rows. In this video you will learn how to select cells and implement different boarder styles easily.
Views: 18514 Learn Excel Online
Microsoft Excel Tutorial 5 How to change cell border style and color
 
02:07
In this tutorial you will learn following things: How can you change selected cell border in different styles? How can you change border color?
Views: 1527 Excel Academy
How to Colour Excel Cells, Font and Border with VBA Macro
 
09:47
This video demonstrates how to write a VBA macro that will: Change the background colour of a cell, Change the font colour Change the border colour. You can specify colour in a number of ways in VBA including built in vb colours and built in rgb colours You can also specify RGB colours using your own red, green and blue values.
Views: 7483 Chester Tugwell
Add all borders to a selected range in Excel using VBA
 
01:34
The video offers a short tutorial on how to add all borders to a selected range in Excel using VBA.
Views: 3431 Prashant Smith
How to Add Table Borders and Shading in Microsoft Word 2016
 
09:36
Get my FREE 2-hour Introduction to MS Word 2016 course here ► https://simonsezit.leadpages.co/word-2016-free-course/ Get the complete 6-hour Microsoft Word 2016 training course here ► https://www.simonsezit.com/courses/microsoft/learn-microsoft-word-2016-training-tutorials/ During this Microsoft Word 2016 training tutorial video, we will talk about Borders and Shading. We will demonstrate how to remove borders or apply borders to certain sides of a table, how to change the border style, how to add color fill and patterns, and how to add art border around your page. Checkout some of our other training on YouTube: Word 2016 training tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jgtGiSa2PZppieNO0_4CUY PowerPoint 2016 training tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jj_QkuckJNn8RddhwlQKOM VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ Excel 2016 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2 Project 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gPqakrFQ8fSNPu00rsOuzu Stay in touch: SimonSezIT.com: http://www.simonsezit.com/ StreamSkill.com: http://streamskill.com YouTube Channel: http://bit.ly/foiItB Facebook: http://on.fb.me/14m8Rwl Twitter: http://bit.ly/177EU5J Google+: http://bit.ly/11JbHdb If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-) Hey. Welcome back. We’re still working in module 6. We’re all the way down now to section 5 where I want to talk to you a little bit about borders and shading. You probably noticed when we were working on the table that you had borders automatically. As soon as you inserted the table you have black borders that print. Well I told you that you have the option to take those off. You can actually add different borders if you’d like just to really enhance your tables. So let me show you a little bit about how borders and shading work. One of the things we talked about was when you first insert a table you automatically will have borders around that table. Borders do print. So if you don’t want them you can take them off, you can actually add different types of borders, different styles, colors, things like that. I’m going to select this table and I’m under the Table Tools contextual tab, the Design tab here. And you can see this is your Borders grouping. I’m going to start with this Borders button here. First of all you’ll notice that several of these look like they’re turned on. This will allow you to put a border around the bottom of your selection, the top, left, right. If you don’t want one of these you just click on it to turn it off. Here’s how you take the border totally off, no border. And if you do that you’ll notice now you have grey what they call Gridlines. Now gridlines do not print. They’re just there to show you the outlines of your cells. Just so you’ll know, if you don’t even want to see the gridlines then you can actually go and turn the view for those on or off under the same Borders button. See how it says View Gridlines here? Well if I click on that now they’re off. Now it looks like there’s nothing there but the table is still there. Your cells still work the same way. It just really would look like nice, neat columns of information versus a table. I’ll go ahead and put these back on. I’m going to choose the outside border option and I’d also like to view those gridlines so that I can work with them a little bit easier. I’ll go down here and choose View Gridlines. Do you notice when I chose Outside Border there’s only a border that will print on the outside of my table? Now I want to apply a border around my header only. So I’ll select the first line, go back to Design and I’m going to choose again Outside Border but this time it’ll be just for the header. So borders are only around your selection, not necessarily each cell in your selection. Notice on this list that you can also apply inside horizontal or inside vertical borders and then you’ve got some diagonal ones you can apply that go sideways like this and then you can also put in a horizontal line. So those are your basic border options. That’s kind of nice but did you notice we can’t really pick a color here or a style, so that’s where it really gets interesting. I’m going to go to the bottom of the list where it says Borders and Shading and click. Now you’ll notice that I have Border options, Page Border options and Shading options. So I’m going to start with the border options. Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.
Views: 14628 Simon Sez IT
How to Apply Line/Border Style in Excel Comment using EPPlus [English]-Part 13(E)
 
06:06
EPPLUS Library - Beginners Guide Part-13(E) Suggested Videos Links: Part 8 - https://youtu.be/qe6bqQmD0Pw Part-9(A) - https://youtu.be/FI9oBBVvduI Part-10(B) - https://youtu.be/48QQgfpNHyc Part-11(C) - https://youtu.be/WjpfRq6vPhY Part-12(D) - https://youtu.be/UlgRnr0HjLc ------------------------------------------------------------------------- How to Create & Apply Line Border Color, Width & Style in an Excel Comment Using EPPlus .Net Application C# [English] - Part 13(E) ------------------------------------------------------------------------------------------------------- Hindi Video Link : https://youtu.be/CSRYZX7LODM ------------------------------------------------------------------------- Blog : https://everyday-be-coding.blogspot.in/p/epplus-library-part-13.html ----------------------------------------------------------------------- Twitter : https://twitter.com/EverydayCoding ----------------------------------------------------------------------- Facebook: https://www.facebook.com/EverydayBeCoding --------------------------------------------------------------------------------- Source code download link: https://goo.gl/EYjAsT --------------------------------------------------------------------------------- We need to attach one more namespace OfficeOpenXml.Drawing.Vml, because in this code we can see LineWidth, LineColor, LineStyle properties. These properties belong to ExcelVmlDrawingComment class & ExcelComment class is inherited from ExcelVmlDrawingComment class so, that's why the object of ExcelComment class gets those properties from his base class. Please see this below code. using (ExcelRange Rng = wsSheet1.Cells["B15"]) { ExcelComment cmd = Rng.AddComment("Comment Text", "Rajdip"); cmd.Font.Bold = true; cmd.Font.Color = Color.Blue; //Apply Line or Border Style in Excel Comment. cmd.LineWidth = 3; Color GreenHexCode = ColorTranslator.FromHtml("#008000"); cmd.LineColor = GreenHexCode; //Color.Green; cmd.LineStyle = eLineStyleVml.DashDot; cmd.Visible = true; } We can use custom color code by using ColorTranslator static class methods a) FromHtml (string htmlColor), b) FromOle (int oleColor), c) FromWin32 (int win32Color). return type of these methods are Color struct object. There is another enum eLineStyleVml is used in this above code. namespace OfficeOpenXml.Drawing.Vml { // // Summary: // Linestyle public enum eLineStyleVml { Solid = 0, Round = 1, Square = 2, Dash = 3, DashDot = 4, LongDash = 5, LongDashDot = 6, LongDashDotDot = 7 } } Here, I am using DashDot, that means 4 within enumerator list. Full Source Code: using OfficeOpenXml; using System.IO; using System.Drawing; using OfficeOpenXml.Drawing.Vml; namespace EpplusDemo { class Program { static void Main(string[] args) { //Code download from: https://everyday-be-coding.blogspot.in/p/epplus-library-part-13.html //Author: Rajdip Sarkar. //Date : 29th July 2017. //My YouTube Channel Link : https://www.youtube.com/channel/UCpGuQx5rDbWnc7i_qKDTRSQ ExcelPackage ExcelPkg = new ExcelPackage(); ExcelWorksheet wsSheet1 = ExcelPkg.Workbook.Worksheets.Add("Sheet1"); using (ExcelRange Rng = wsSheet1.Cells[2, 2, 2, 2]) { Rng.Value = "Everyday Be Coding - Excel COMMENTS Formatting using EPPlus .Net Library - Part 13(E)"; Rng.Style.Font.Size = 16; Rng.Style.Font.Bold = true; Rng.Style.Font.Italic = true; } using (ExcelRange Rng = wsSheet1.Cells["B5"]) { Rng.Style.Font.Size = 20; Rng.Value = "Excel Comment Border Style"; ExcelComment cmd = Rng.AddComment("Comment Text", "Rajdip"); cmd.Font.Bold = true; cmd.Font.Color = Color.Blue; //Apply Line or Border Style in Excel Comment. cmd.LineWidth = 3; Color GreenHexCode = ColorTranslator.FromHtml("#008000"); cmd.LineColor = GreenHexCode; //Color.Green; cmd.LineStyle = eLineStyleVml.DashDot; cmd.Visible = true; } wsSheet1.Cells[wsSheet1.Dimension.Address].AutoFitColumns(); ExcelPkg.SaveAs(new FileInfo(@"D:\FormatComments.xlsx")); } } } Now build & execute this code. The file is (FormatComments.xlsx) store on D: drive of the computer. Thank you for reading this article. Please subscribe my YouTube Channel & don't forget to like and share.
Views: 184 EVERYDAY BE CODING
How to use Border options | Complete Border options | in ms excel in hindi Topic - 8
 
06:59
Hello, guys welcome to our computer education channel. Our channel provides you education and tips and tricks. We uploaded many videos in a month for provided education about the computer because today and future is the time of uses computer. Our channel also makes many series which is you can see in a playlist. We try to provide you all stuff about computer knowledge and tips and tricks. So you can also support us by subscribe our channel and by like, share our videos. Thank-you #bordaroption #excel #hindi Join Whatsapp Group Link For You Help - https://chat.whatsapp.com/EbA7uRaFcFvAR2cpwhnfJ5 LEARN FULL COMPUTER COURSE [CLICK NOW] https://goo.gl/NYSnSu Learn Full Wordpad in Hindi [CLICK NOW] https://goo.gl/cPB2Dn Complete NotePad in Hindi [CLICK NOW] https://goo.gl/tjLtAZ Learn Full Computer Course Step By Step in Hindi [CLICK NOW] https://goo.gl/FYtqQ6 Learn Full Ms Excel Step By Step Latest Version [CLICK NOW] https://goo.gl/tb4vFD Learn Full Ms Word Step by Step Latest version [CLICK NOW] https://goo.gl/9iahg5 Learn Basic Computer New Series [CLICK NOW] https://goo.gl/vQDSyG Select the cells you want to format. Click the down arrow beside the Borders button in the Font group on the Home tab. A drop-down menu appears, with all the border options you can apply to the cell selection. Use the Borders button on the Home tab to choose borders for the selected cells. Use the Borders button on the Home tab to choose borders for the selected cells. Click the type of line you want to apply to the selected cells. When selecting an option on the Borders drop-down menu, keep these things in mind: To have Excel draw borders only around the outside edges of the entire cell selection (in other words, following the path of the expanded cell cursor), click the Outside Borders or the Thick Box Border option. If you want borderlines to appear around all four edges of each cell you’ve selected, select the All Borders option. To change the type of line or line thickness or color of the borders you apply to a cell selection, open the Format Cells dialog box and use the options on its Border tab (click More Borders at the bottom of the Borders button’s drop-down menu or press Ctrl+1 and then click the Border tab). Insert or remove cell borders on a worksheet Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 You can add a border around cells to distinguish specific values, outline summarized values, or separate data into ranges of cells. To quickly add an outside border, simply select the cells that you want to include and press Ctrl+Shift+7 on your keyboard. Follow these steps to add borders by selecting different line styles and colors: Select the cell or range of cells. On the Home tab, click the arrow next to the Borders icon, and from the drop-down menu, choose the border option that you want to apply. Tip: The Borders button shows the most recently used border style. To apply the same style, click the Borders button (not the arrow). The Borders option To remove all borders: Select the cells from which you want to remove borders, and then choose No Border from the menu.
Views: 57 ShubhBE Education
Make an Excel border line thinner than standard
 
01:42
border Excel Excel 2010 Excel 2013 Excel 2016 thin thinner print pdf When you convert/print a page from Excel to pdf, the borders of the cells (or tables) are shown in real bad quality .(light lines get thick and clumsy ). I tried all different settings and versions (Excel, Word, Acrobat). Nothing helps. Here is the an alternative solution to this problem. Just follow this tutorial and we'll show you how it's done.
Views: 1766 Abbassi Tarek
MS Access: Menu Style that Uses Tab Control, Tag Property, and VBA.
 
06:20
This video describes how you can use a custom tab control to create a clean, uncluttered main menu in your database. If you want a lot of options available on your main menu, but also want to keep it looking tidy and streamlined, you can use this method to hide or show controls depending on custom tag properties. For more information or to get the sample file, please email me at hello @ smallbiztlc dot com. Don't leave your email address in your comment -- youtube marks it as spam and I don't see it. Please email me at the hello address. Thank you.
Views: 34330 smallbiztlc
Macro Monday Add Borders and Auto Fit Columns Solution - Code Included
 
08:02
Here is the solution for Adding Borders for Auto Fit Columns 'Code: '============== Sub AddBorders() ' ' AddBorders Macro ' ' Range("B11").CurrentRegion.Activate Selection.BorderAround xlThin ' Selection.Borders(xlEdgeLeft).Weight = xlThin ' Selection.Borders(xlEdgeTop).Weight = xlThin ' Selection.Borders(xlEdgeBottom).Weight = xlThin ' Selection.Borders(xlEdgeRight).Weight = xlThin Selection.Borders(xlInsideVertical).Weight = xlThin Selection.Borders(xlInsideHorizontal).Weight = xlThin Columns("C:F").EntireColumn.AutoFit End Sub
Views: 549 EverydayVBA
How to make a border-less form on VB.net? Customize your own windows forms.
 
04:15
Customize your own windows form in VB.net. This is fun and more appealing way to see the forms in different styles and colors.
Views: 7034 Admin Panel
Excel Macro in Bangla 03 :Change text color & Border Excel  VBA Macros Bangla Tutorial
 
14:21
Excel VBA Bangla Magics Tricks 03 :Change text color & Border Excel VBA Macros Bangla Tutorial Change text color & Border Excel VBA Macros Bangla Tutorial কিভাবে Text, Border color change করবেন How to change text color & border in Excel by VBA Macros ( Basic to Advanced ). When you will see this video, you will make easily. If you want to practice, please download working file from below link https://drive.google.com/drive/u/1/folders/1UAFUMH7C-lpSBdackcJ_fS3asgg7F1BM
Views: 308 HASAN ACADEMY
Format all Instances of a Word in a Range using Excel VBA
 
09:10
http://www.computergaga.com/blog/format-specific-words-in-a-cell-using-vba/ Format all instances of a word in a range using Excel VBA. This video demonstrates a macro using VBA that will search through a range of cells for all instances of a word, and if found will format it a different colour. This macro will only format the word if it is a whole match. It is also case sensitive. Follow the link below for the VBA code used in the macro. http://www.computergaga.com/blog/format-specific-words-in-a-cell-using-vba/ Learn Excel VBA online https://www.udemy.com/excel-vba-course/?couponCode=ExcelVBAYouTube Connect with us! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► http://www.twitter.com/computergaga1
Views: 1743 Computergaga
Excel - Format Cells Font and Borders
 
10:16
Check my blog here: http://www.techtutorialvideo.com/ This is another Microsoft Excel basic tutorial. In this tutorial we can learn about formatting cells using fonts and cell borders. Also at the end of the tutorial there is a useful excel tip. Formatting cells in Microsoft Excel is very important in order to show data in meaningful way and to provide better presentation. This tutorial will give us idea about how to work with fonts and borders. It shows one of the cool features of Microsoft Excel 2007 and 2010 where we can preview data before applying a font. It also includes how to work with customized cell borders, border colors and border styles along with all predefined borders. Some hot keys: Bold : CTRL + B Italic : CTRL + I Underline : CTRL + U So check this video tutorial for the details of font and borders for formatting a cell. If you have any question/ comment/ suggestion; please use the comment section to reach me.
Views: 8789 TechTutorialVideo
Learn Excel 2010 - "Conditional Diagonal Borders": Podcast #1538
 
04:02
From Jumping Bean on YouTube, the question: "How can I apply Conditional Formatting to Double the Diagonal Borders when the Value is a Number?" In Episode #1538, Bill offers a method to 'cross out' only Numeric Values in each cell. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! "The Learn Excel from MrExcel Podcast Series"
Views: 3412 MrExcel.com
VBA Excel Macro - (6.2) - Range Formatting(Color,Size,Font)
 
10:02
This video explain about the formatting of Range object. How to change cell colour, font colour, font style (Bold,italic,underline) and also font (Ariel,Times New Roman). At the video explains about font size change. Ready Reckoner: https://drive.google.com/open?id=1ERAdRvd3dIG1etA_rSvH7IMGpLZlX9xA Exercise File: https://drive.google.com/open?id=1jIz-qEwE0cbmHzuI-V4A_45WlwrwSVug In this video, we will cover below topics. Range Format Properties Cell/Font color change Cell/Font size change Font style change For any doubt or clarification, please comment or connect me at any of the following : Gmail: [email protected] LinkedIn : https://www.linkedin.com/in/amitamu Instagram: https://www.instagram.com/python.coding Twitter: https://twitter.com/amitamu Quora: https://www.quora.com/profile/Amit-Kumar-85 Facebook: https://www.facebook.com/curquest/
Views: 398 curquest
CSS Tutorial for Beginners  03 - Border style Property
 
16:55
CSS Tutorial for Beginners CSS border properties in this video i will show you CSS border style property with define a class, how to add border color in css.
Views: 183 Programmer Guruji
Apply, Change or Remove Cells Border and its Color - Excel
 
02:07
This is a simple tutorial to add, change and at last remove cells borders with its color in Microsoft Excel. This very helpful video for beginners. Let's watch it and enjoy!!! 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 17189 pc shastra
Excel 2013 for Beginners Part 21: How to Add Cell Borders in Excel 2013
 
10:04
Get my free 3 hour Excel 2013 course: https://simonsezit.leadpages.net/free-excel-2013-course/ Get 17 training videos to help you learn MS Excel 2013. Borders can provide a very good way of focusing attention on to the key points of a worksheet and can also help to segregate data and data types. In this video tutorial, you are going to learn more about how to apply borders and some of the border patterns that you can choose from. Learn also how to apply borders when using a touch screen. All these and more in this video. Get over 70 hours of Microsoft Office 2013 training here course here: http://bit.ly/office-2013-training Stay in touch: StreamSKill.com: http://streamskill.com/ SimonSezIT.com: https://www.SimonSezIT.com/ The Simon Sez IT email newsletter: http://bit.ly/18bMwY0 YouTube Channel: http://bit.ly/foiItB Twitter: http://bit.ly/177EU5J Google+: http://bit.ly/11JbHdb If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -) Welcome back to our course on Excel 2013. In this section, we’re going to finish off our review of the basics of formatting a worksheet and we’re going to concentrate on Borders in this section. But before we do, there’s just one other little thing I want to cover on Styles. In the previous section, we applied a style to a couple of the heading and a couple of columns on this worksheet and we also applied some direct formatting to the Cost and Recharge columns. If you want to remove a cell style, it’s pretty straightforward. Let’s take this particular one. We applied a cell style to the category cells here. If I go into the Cell Styles Command in the Styles Group on the Home tab, if at any stage you want to remove the style from a cell, all you have to do is select Normal. And when you select Normal, then the Style selection you previously applied is removed and the cell style, the default cell style is Normal. Pretty much the same as it is in a program like Word. So every cell by default has a format of Normal and you’re applying other than normal styles to achieve the sort of affects that we’ve looked at so far. The main formatting option I want to look at in this section is the use of borders and borders can provide a very good way of focusing attention on to the key points of a worksheet and also can help to segregate data and data types. If we take this particular expenses sheet that we’ve got here, if I were to select all of the cells that actually have data in them, so I’m going to start at A1, mouse down and drag down to F8. So I’ve got everything selected. I can apply a border very simply. If you look on the Home tab in the Font Group there is here a Bottom Border button or what appears to be a Bottom Border button. But if I click on the drop down, I’ll see that I actually have a whole range of border options. Now the reason that it says Bottom Border there on the button is that when you select one of the border options the one you select becomes the one on that button. It gives you a one click access to one of these many options. Now let’s look at some of the options. If I’ve got a group of cells selected which at the moment I have and I were to just click, for example, Bottom Border. Let me do that and click away. What you should be able to make out is that there is now a border but only at the bottom of the group of cells that I had selected. Let me select again. Now this time what I’m going to do is I’m going to select All Borders. Now watch what happens this time. Now again I’ll click away and you’ll now see that I have a full set of borders everywhere and this also emphasizes, of course, the merged cell in the first row. So that’s basically how borders work and it shows you how straightforward it is to put borders on a selection. Now sometimes you may want something other than the default bordering that occurs with Excel 2013 and you can actually change a lot of aspects of the bordering. For example, let’s suppose that I wanted to really emphasize the Cost column here. If I select that column with its heading of Cost and go back into the drop down next to the Borders button note the Borders button is now All Borders because that’s the last Command I executed. Click on there and this time say Thick Box Border, click away. You notice that the outer box border on those selected cells is now thicker than the others. Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.
Views: 12522 Simon Sez IT
CSS3 Tutorial for Beginners: 24 Editing The Border Property (Width, Style, Color)
 
07:16
CSS3 Tutorial for Beginners: 24 Editing The Border Property (Width, Style, Color) ★ SUMMARY ★ Today I'd like to show you how to edit the border property when it comes to your website's box elements. In this video you're going to learn exactly how to change the thickness of your borders, making them thin, medium or thick, we'll talk about how to change the border type, such as solid, dashed or dotted, and also you'll see how to change the border color. We'll take a look at how to add a border only to a specific side of the box, and also I'll show you the short way of editing all the border properties at once. Read the full post at https://backstageincome.com/blog/css3-24-border-property/ ★ TOOLS FOR THIS TUTORIAL ★ SublimeText: https://www.sublimetext.com/ Atom: https://atom.io/ Chrome : https://www.google.com/chrome/ Autorefresh plugins: https://chrome.google.com/webstore/search/auto%20refresh?hl=en-US ★ START & BUILD YOUR ONLINE BUSINESS ★ https://backstageincome.com/go/start/ ★ MY BUSINESS TOOLS ★ https://backstageincome.com/go/tools/ ★ MY CAMERA GEAR ★ https://backstageincome.com/go/vidtools/ ★ MY COMPUTER EQUIPMENT ★ https://backstageincome.com/go/computergear/ ★ SHARE THIS VIDEO ★ https://youtu.be/PrmR-eshh8c ★ SUBSCRIBE TO MY YOUTUBE: ★ http://bit.ly/getbackstage ★ ABOUT BACKSTAGE INCOME ★ On Backstage Income, we discuss how to build and grow yourself personally as well as your business. Income is not just about money - but about coming in and entering. Here we share how to grow the various moments coming into your life from your financial wealth, business, but also personal growth. If you are interested in exchanging ideas, want to contribute, or just have some thoughts to share - we'd love to have you subscribe and join us! BUSINESS COURSES: - https://backstageincome.com/go/bizcourses/ BUSINESS BOOKS: - https://backstageincome.com/go/bizbooks/ WEBSITES: - https://backstageincome.com - https://mylittlenestegg.com - https://rise2learn.com - https://tradersfly.com - https://sashaevdakov.com - https://criticalcharts.com SOCIAL MEDIA: - https://facebook.com/sashaevdakov - https://twitter.com/sevdakov MY YOUTUBE CHANNELS: - TradersFly: http://bit.ly/tradersfly - BackstageIncome: http://bit.ly/backstageincome
Views: 154 Backstageincome
Excel VBA #Change Font and Background Color of Cells
 
06:44
Change Font and Background color of a Range in Excel VBA. We have three ways to apply these colors with different coding. These types have different limitations. I'll show examples how to change Font Color in Excel using VBA. In my next tutorial my subject would be more effective. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 6450 pc shastra
6 ( Excel) How to Apply Borders Inside Excel
 
03:44
In this short Tutorial , i demonstrate on how to use borders inside excel .... Hope this helps , Cheer's, Amlan Please Check my facebook page www.facebook.com/filingreturnsonline where i keep on adding more stuff and where you would find all the stuff that i have created till date .
Views: 4463 Make Knowledge Free
Access 2013: Customizing Form Settings
 
03:33
In this video, you’ll learn more about customizing form settings in Access 2013. Visit https://www.gcflearnfree.org/access2013/creating-forms/1/ for our text-based lesson. This video includes information on: • Customizing form settings with the Property Sheet • Modifying form settings • Hiding a field • Setting a field to auto-fill with the current date We hope you enjoy!
Views: 21222 GCFLearnFree.org
How To Change Border Color || Font Color & Using Fill Color Options In MS Excel-Lession-7
 
08:32
Ms Excel ke is lession me aaj aap sikhne Home tab ke Font block ke under Border Color, Font Color & Fill Color Options ka use karna. How to use Border in table? How to change font color? How to use fill color option? Shift+ bottom arrow Select cells. Alt+Shift+F1 Insert New Worksheet. Shift+F3 Open the Excel formula window. Shift+F5 Bring up search box. Ctrl+1 Open the Format Cells window. Ctrl+A Select all contents of the worksheet. Ctrl+B Bold highlighted selection. Ctrl+I Italic highlighted selection. Ctrl+K Insert link. Ctrl+S Save the open worksheet. Ctrl+U Underline highlighted selection. Website Links: Learn Ms Excel In Hindi कम्‍प्‍यूटर सीखें हिन्‍दी में: http://learningtpoint.com/excel_application.php Explore Windows:http://learningtpoint.com/Excel_Explore_Windows.php Worksheet, Rows, Columns and Cells:http://learningtpoint.com/Worksheet_Rows.php Create New Worksheet:http://learningtpoint.com/Creating_New_Worksheet.php Moving on worksheet:http://learningtpoint.com/Moving_Worksheet.php Insert Data:http://learningtpoint.com/Insert_Data_Excel.php How to delete data, rows and columns:http://learningtpoint.com/Delete_Data_Excel.php Move Data:http://learningtpoint.com/Move_Data_Excel.php Addition in Microsoft Excel:http://learningtpoint.com/Addition.php Subtraction:http://learningtpoint.com/Subtraction.php Sigma Addition:http://learningtpoint.com/Sigma_Addition.php Data Filtering:http://learningtpoint.com/Data_Filtering.php Data Sorting:http://learningtpoint.com/Data_Sorting.php Styles:http://learningtpoint.com/Using_Styles.php Applying Themes in Excel:http://learningtpoint.com/Using_Themes.php MS Excel 2007 Playlist - https://youtu.be/m8RJ5MgqQl8 इस विडियो में आप जानेगे MS Excel 2013 का परिचय In this video you will know about the introduction of Microsoft Excel in Hindi 📷📷📷👉To Watch Video Tutorials :https://www.youtube.com/channel/UCQPBiQvcyWXiEJkNQB1ZIeg For More Info Please Visit Our Website: http://www.learningtpoint.com/ Facebook: http://www.facebook.com/learningtpoint दोस्तों विडियो पसंद आए तो like comment share & subscribe कर सकते है . https://www.youtube.com/channel/UCQPBiQvcyWXiEJkNQB1ZIeg
Views: 21 Learning T point
Excel VBA - Chart Styles
 
18:54
Excel consists of different types of charts. Each and every chart consists of different styles. In this video i would like to explain how to create chart with all the available styles
Views: 139 Pavan Kumar
Dynamic border to a list using excel conditional formatting
 
01:13
Dynamic border to your list with formulas for borders
Views: 2485 excel Crazy
Excel VBA Basics #18 - Change the Font Type, Size etc using VBA!
 
05:48
In this lesson, we learn about the .FONT properties that can be easily manipulated in your Macro or code. Check it out! **Limited Offer** Learn to Make Excel Do Your Work For You with The Ultimate Excel Programmer Course – Get the Full 9+ Hour Premium Course for 75% off using coupon code: https://www.udemy.com/ultimate-excel-programmer/?couponCode=2016YOUTUBE75 Click Now to Order and get Lifetime Access to Course, Workbooks, Updates and Support! ------------------------ Create Your Own Barcode Lookup System Using Excel VBA. Learn to Make Your Own Barcode Labels the Easy way and have fun with Barcode Scanners to Automate your Workflow! In this project-driven Course, you’ll learn to Build your own Custom Inventory System with Step-By-Step video instructions. This goes in depth into some advanced Userform strategies that you can use for your other projects to come. A great weekend study! YouTube Subscibers only pay one forth! Get your 75% off Coupon here: https://www.udemy.com/barcodes-excelvba/?couponCode=2016YOUTUBE75 ------------------------ Too busy to Learn Piano? Use my Secrets and Play Your Favorite Songs Today! Did you know; You can learn 4 basic chords in about 5 minutes and instantly be able to play millions of songs. Seriously, check this course out. 75% off for my YouTube Friends! Click here: https://www.udemy.com/play-piano-by-ear-today-supercourse/?couponCode=2016YOUTUBE75 For Articles, Updates and to Contact me for Consulting or just to drop me a line, please visit http://www.ExcelVbaIsFun.com Here is my link to download my FREE workbooks, past present and future: https://www.dropbox.com/sh/nwc5trm2xwlvvbh/XpGTrmKVyQ ------------------------ Playlists: Excel Vba Basics http://www.youtube.com/watch?v=AIhKNNXzZLM&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR&index=1 Tips N Tricks https://www.youtube.com/playlist?list=PLw8O1w0Hv2zsPU-k2vPZ_6brD5Gk1sVy_ Userforms https://www.youtube.com/playlist?list=PLw8O1w0Hv2zvnLFyiMrihcaOqA0sT0X2U Sample Excel Programs https://www.youtube.com/playlist?list=PLw8O1w0Hv2zuP-BE7tV1UjWa0ZexZqY89 Events Series https://www.youtube.com/playlist?list=PLw8O1w0Hv2zvf-YaBApsIHloI9G6Cq1Wh Activex Controls https://www.youtube.com/playlist?list=PLw8O1w0Hv2zupzNIWkZCOYYngTtMH5nSf ------------------------ Grab an Excel Nerd T-Shirt or Hoodie: http://ExcelVbaIsFun.spreadshirt.com/ ------------------------ Interact and Follow me on: LinkedIn: http://www.linkedin.com/in/danielcstrong Facebook: https://www.facebook.com/Excelvbaisfun/ Twitter: https://twitter.com/ExcelVbaIsFun Google Plus+: http://www.google.com/+ExcelVbaIsFun 'Royalty Free Music by http://audiomicro.com/royalty-free-music'
Views: 35630 ExcelVbaIsFun
Working with font styles and background colors in excel using VBScript
 
30:56
This video explains how to work change the font style and back ground color of a cell in Excel using VBScript. Same script can be used in VBA (Macros)
Views: 1022 nanda.D Reddy
VBA Part 7 - Change Font Size, Italic, Bold, Underline, Name
 
14:46
Change Font Size, Change Font to Italic, Make Font Bold, Underline any string, Change Font Name and style....
Views: 162 Aman Panday
How to change the Form Border Color of a windows Form in vb.net.
 
02:58
LINK DOWNLOAD CODE: https://1drv.ms/f/s!AnxB4X06zx0rziTeN2Y8q9ufO38E
Views: 6794 Almeida
Apply Conditional Formatting to Shapes in Excel
 
05:43
Learn 2 ways to apply conditional formatting to shapes in Excel. This technique is great for dashboards and interactive reports where you don't want to be confined to the grid layout of the cells. There is no way to actually apply conditional formatting to shapes in Excel, so both these methods are workaround solutions. Here is the link to the article and page where you can download the sample Excel file: http://www.excelcampus.com/tips/conditional-formatting-shapes/ Method #1: A simple solution is to copy and past e the cell that contains conditional formatting as a Linked Picture. The paste special linked picture command will create a shape that displays the formatting and values of the cell. As the cell's value and formatting changes, the linked picture will also update to reflect the changes. You can use this technique for a single cell or a range of cells. The picture is resizable so you can make the shape bigger for your dashboard. You cannot change the shape type directly in the Excel menus or ribbon. However, you can use VBA to change the shape type. The following line of code will change the shape type of the selected shape with VBA. Selection.ShapeRange.AutoShapeType = msoShapeRightArrow Method #2: The CF Shapes Add-in allows you to create custom shapes with conditional formatting for the shapes fill color. Click the following link to learn more about the CF Shapes Add-in: http://www.excelcampus.com/cfshapes If you are new to conditional formatting or really want improve your skills then I highly recommend the Conditional Formatting Video Course by Dave Bruns at ExcelJet.net. Here is the link to learn more about the course: http://www.excelcampus.com/exceljet-conditional-formatting-course
Views: 48765 Excel Campus - Jon
Keyboard Shortcut to Apply or Remove Outline Border in Excel
 
00:52
Shortcut key to apply or remove outline border in Excel. This video really help you. This is simple and short time video, you must watch. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Views: 17480 pc shastra
MIcrosoft Access Developer Level 12 - Introduction
 
05:02
Access Developer 12 continues our focus on learning how to program the Visual Basic for Applications programming language (VBA) in Microsoft Access. Topics include: - Universal Dialog Box, Parts 2 & 3 - Add OK, Cancel Buttons - DoEvents in Timer Loops - Global Variables, While Loops - Custom Form Positioning - Move, Resize Form Windows in VBA - Twips, InsideHeight, InsideWidth - External String Manager - Dynamic Labels on Forms and Reports - Lots more This is the introduction video only. The full course is 1 hour and 50 minutes long and can be found on my web site at http://599CD.com/X4T2Q5 This class continues our look at programming in Visual Basic for Applications in Microsoft Access (VBA, or Access VB). We're continuing on with the Test Taker database and the Universal Dialog Box that we started in Developer 9. First, we'll add OK and Cancel buttons to the uDialog and see how we can return a value to the code that called the box. We'll learn about global variables, while loops, and the DoEvents command. Next we'll study custom form positioning. We'll learn about the different types of form window dimenstions: Height, Width, InsideHeight, InsideWidth, WindowTop, WindowLeft, and so on. We'll learn what Twips are and how they relate to pixels and screen inches. We'll see how to resize and move form windows using the Me.Move and MoveSize commands. We'll use the OnResize event, and see how we can use a timer to check if a form is moved. We'll learn how to center a window on the screen. Moving back to the uDialog box, we'll learn how to resize the individual controls on the form, such as the prompt label. We'll have to use a little math to calculate the dimensions of the form window and the size of the command buttons to move and resize the OK and Cancel buttons correctly, but it can be done. Finally, we'll build an External String Manager. If you have ever had to support multiple copies of a database for different types of users, such as users who speak different languages, then this concept will be perfect for you. Instead of keeping two or more separate front-end forms, or even whole databases, you can use a table to store the strings in them (such as "First Name") and then pull those in based on the language preference of your user. This will be a collection of events, a few support tables, a DLOOKUP or two, and we'll make our own custom GetString function. This is the 12th class in the Access Developer series. If you're serious about building quality databases with Access, and you want to learn how to automate your database with VBA Programming then don't miss out on this course. Of course, if you have any questions about whether or not this class is for you, please contact me. 00. Intro (5:01) 01. Universal Dialog Box 2 (21:28) OK, Cancel, Yes, No Buttons Turn Sub into Function Global Variables While Loops While Wend DoEvents Return Function Value 02. Custom Form Positioning (23:49) Height and Width of Forms Twips = Inches * 1440 Twentieth of an Inch Point Design Time Width of Form Me.Width Runtime Width of Form Me.InsideWidth OnResize Event WindowHeight, WindowWidth - Read Only Me.Detail.Height Me.InsideHeight There is no OnMoved event You can use a timer event OnTimer Twips Round to 15 Me.Move Docmd.MoveSize Center Form On Screen AutoCenter 03. Universal Dialog Box 3 (35:14) AutoCenter Not exactly in the center of the screen uDialog Left, Top, Height, Width Size of Controls in Form Resize Prompt Label on Form Resize Border Style Sizable, Dialog Move Buttons as Form is Resized Button Top, Left One or Two Buttons Visible 04. External String Manager (21:59) Multi-Language Database Don't Design Multiple Forms or Databases Different Prompts on Forms and Reports Create User Settings Table For Multiple Users See Security Seminar Create String Table Dynamic Labels on Customer Form Label Caption Property Dynamic Labels on Customer Report Create External Module GetString Function Use GetString as a MsgBox String 05. Review (2:31) Learn more about Microsoft Access here: https://en.wikipedia.org/wiki/Microsoft_Access https://products.office.com/en-us/access https://www.microsoft.com/en-us/microsoft-365/blog/access/
Introduction to Excel VBA - Module 04 (Font Formatting)
 
07:23
This is a part of a series of lessons on VBA. ' In this lesson, I demonstrate how to format cells Be sure to check out the other videos in this series and other series we have posted.
Excel tips and tricks: How to implement VBA macro to color charts according to source cells
 
05:04
For more information, see http://Excel4Everything.blogspot.com
Views: 3995 Excel4Everything
How to Add Page Border in Microsoft Excel 2017
 
02:01
Excel Tutorial- How to Add Page Border in Microsoft Excel 2017. Firsly chooses the paper size. Then Go to the home menu and select the table border. ** Premium Service ** https://goo.gl/6VDdks https://goo.gl/MfPeid Facebook Page: https://goo.gl/mVvmvA https://goo.gl/FmZ84U Please Subscribe My Channel: https://goo.gl/9kkcty Disclaimer- Some contents are used for educational purpose under fair use. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.
Views: 8727 PDFEditing
Change a font , font size, font color, and border in Excel
 
01:08
excel, microsoft excel, Change Font, Font Size, Font Color and Border
Views: 31 Vivek Kumar