Excel Tips


Excel Shortcuts - Ctrl+Arrow to Navigate »

July 25, 2017

Jump to the edge of your Excel data using Ctrl + [Shift] + Arrow to quickly navigate.


Perfect 1-Click Charts »

July 24, 2017

You do not have to re-create your charts each month


Excel Shortcuts - Ctrl+1 »

July 24, 2017

Excel Keyboard Shortcuts: Ctrl+1 to format the selection. By far, this was the most popular in our poll of your favorite Excel shortcut.


Recover Unsaved Workbooks »

July 21, 2017

Thanks to Office MVP Beth Melton for rounding out my knowledge of this trick.


Provide Feedback with Sound »

July 21, 2017

Here is an interesting new feature in Excel: you can have Excel provide gentle sounds to confirm that you have completed a specific action. While this is meant as an accomodation tool for people with visual disability, it might be of interest to the general population of Excellers.


Workbook Defaults »

July 20, 2017

Start with a blank workbook with a single sheet


Keep the Copy »

July 20, 2017

New feature in Excel: Say that you copy some data. You then Insert Rows. The data on the clipboard is deleted. It is frustrating. But there is now a fix in Excel.


Sideways with Formula »

July 19, 2017

Paste Special Transpose does a snapshot of the data


Compare Sheets Side by Side »

July 18, 2017

Paste Special Transpose does a snapshot of the data