New Excel Help Service!

We need your input to help create a new Live Online Excel Help service.

Please take our survey and let us know your thoughts!

Excel Survey

Have a great day!

Don


Featured Excel Content



Excel Tip
How to remove the flashing dashes from a copy/paste range using VBA in Excel; this removes the dashed outline that appears once a paste has been completed using a macro. Sections: The Code Useful Example Notes The Code Application.CutCopyMode = False Put this piece of code anywhere after you finish copying and pasting a range. Useful Example Sub co ...
Added: Feb 9, 2017
 
Excel Tip
Run a macro every 30 seconds, 1 minute, 10 minutes, 1 hour, etc.; this method allows you to run a macro at any set interval. Sections: The Code Stop an Interval Macro Notes The Code Sub macro_timer() 'Tells Excel when to next run the macro. Application.OnTime Now + TimeValue("00:00:10"), "my_macro" End Sub Sub my_macro() 'Macro code that you want t ...
Added: Feb 8, 2017
 
Excel Tip
How to copy and paste data using a Macro in Excel. I'll show you multiple ways to do this, including across worksheets and workbooks. Sections: Simple Copy/Paste Copy Entire Range Copy between Worksheets Copy between Workbooks Notes Simple Copy/Paste Range("A1").Copy Range("B1") This copies cell A1 to cell B1. Range("A1").Copy is the part that copi ...
Added: Feb 7, 2017
 
Excel Tip
How to print pages in Excel with different headers for odd and even pages. Steps Go to the View tab and click the Page Layout button on the left. The spreadsheet will then change to look like it will when you print it. Click at the top of the page to add a Header or the bottom to add a footer. Once you have clicked in the header or footer, look to ...
Added: Feb 6, 2017
 
Excel Tip
Multiple ways to zoom into Excel using the keyboard and mouse. Ctrl + Mouse Wheel Alt + V + Z Alt + W + Q Pinch the touch pad in or out with two fingers at the same time (good for laptops). When you use the keyboard shortcuts, you will see a window like this: You can then hit one of these keys and Enter to quickly zoom to a certain level: 1 - 100% ...
Added: Jan 25, 2017
 
Excel Tip
Here is an Excel formula that will act like a Vlookup that returns every matching result from a list. Note: all formulas below are array formulas and so must be entered using Ctrl + Shift + Enter. Sections: The Formula Formula That Hides Errors Notes The Formula =INDEX($B$1:$B$7, SMALL(IF($A$1=$A$1:$A$7, ROW($A$1:$A$7)-ROW($A$1)+1), ROW(1:1))) Thi ...
Added: Jan 24, 2017
 
Excel Tip
How to make Excel easier to read by increasing the font size or zooming in. Sections: Increase Font Size Zoom Notes Increase Font Size You can increase the default font size for the entire workbook in Excel. Go to the File menu and click Options: In the General tab go to the Font Size section and adjust the font size accordingly: Now, when you open ...
Added: Jan 23, 2017
 
Excel Tip
Get a list of all files from a directory into an Excel worksheet. This allows you to navigate to anywhere on your computer and have a listing of the files within the directory output into Excel. This macro works by allowing you to visually navigate through your computers directories until you find the one you want and then, when you click the OK bu ...
Added: Jan 18, 2017
 
Excel Tip
How to include different information, headers, or footers, on the first page when printing an Excel spreadsheet. Steps Go to the View tab and click Page Layout. Click at the top of the page where it says Click to add header or click the bottom where it says Click to add footer. Click the Design tab that should have now appeared and put a check nex ...
Added: Dec 20, 2016
 
Excel Tip
This feature allows you to view multiple worksheets from the same workbook at the same time. Steps Go to the View tab and click New Window Then click Arrange All Select either Horizontal or Vertical  and put a check next to Windows of active workbook and then click OK. You will now have two separate views of the same workbook. You can view differen ...
Added: Dec 19, 2016
 
Subscribe for Free Excel tips & more!
E-mail: