Microsoft Excel articles
Two-Line Custom Formats Excel is very flexible in how it will allow you to set up custom formats for displaying all manner of values. Most custom formats are straightforward and easy to figure out once you have an understanding of how custom formats work. Suppose […]
How To Create Two-Line Custom Formats Read More »
If you work with large Excel workbooks that contain multiple tables, it can become very tedious moving from one to the other. This is a quick and easy way to do just that and I think you will love it. Follow the steps below to
How To Navigate Through Multiple Excel Tables Read More »
I have a subscriber who regularly adds lines and arrows to flowcharts that she has created in Excel. She inquired whether there is a way to set a default line weight, color, and arrow because it is very tiresome changing the attributes all the time.
How To – Default Excel Attributes for Lines/Arrows Read More »
I believe it is a truism that whenever you add something, you will later want to delete it. When you have finished with a project or you do not have a need for a particular view, you will want to get rid of it. Follow
How To Delete A View In Excel Read More »
New Workbook Version I am sure that like me, you have some Excel Workbooks that you open from time to time, edit to make changes, and then click Save As and save as a new version so your original Workbook remains the same, right? I
How To Open A New Version Of Your Workbook Read More »
Suppose you have a custom footer that you would like at the bottom of all the pages in your worksheet. Left-justified in the footer, you would like the full path name for your worksheet, and centered you would like a page number in the format
How To Move Part Of Footer Down One Line In Excel Read More »
Range Names Named ranges can be great when you are writing formulas. Suppose if you assign the name WidgetPrice to cell A5, you can then use that name, WidgetPrice, in your formulas instead of A5. This will make your formula (and its purpose) easier to
How To Apply Range Names To Formulas In Excel Read More »
Excel One-Click Worksheet Functions When you are editing your worksheet, or inputting new data, you can click the Insert Function button on the Formula Bar of your Ribbon. Alternatively, you can click Shift F3. This will open the Function Argument dialog, which will give you
How To Get More Help With Excel Worksheet Functions Read More »
Repeating Last Action There is a key that is hardly used and yet is a highly efficient shortcut for speeding up tasks in Word and Excel when you need to repeat the same action, once, twice or many, many times! That key is the F4
How To Quickly Repeat Last Action In Word/Excel Read More »
Quick Print In Excel Should you need to quickly print the contents of a workbook without opening the workbook yourself manually, you can absolutely do this! Follow the steps below to learn how: Use the Explorer, My Computer or any Open dialog box to locate
How To Quickly Print Without Opening In Excel Read More »
Microsoft Excel I saw an article recently regarding this topic. I had never really thought about doing this before, but it is nice to know that if I needed to, I could probably work it out. I thought it prudent to share this information with
How To Insert Watermark Behind Merged Cells Read More »
How many times have you been typing away only to glance down and discover that Caps Lock is on? Fortunately, Excel can catch these errors for you – IF I tell it to! Follow the steps below to learn how: On your Ribbon, Click the
How to Correct Capital Mistakes in Excel Read More »
There are many reasons why you might want to control a user’s input in a worksheet. My number one reason is that it saves time and keystrokes and everyone knows how much I love that! Another reason is that it will limit the choices and
How to Use a Custom Drop-Down List for Choices in Excel 2010 Read More »
Many folks use merged cells in their worksheets and they can definitely be helpful, but many times merged cells can cause you untold heartburn when selecting ranges, sorting and other functions we use in Excel every day. Even if you do not use merged cells
How to Find all Merged Cells in an Excel Worksheet Read More »
