Skip to content

Useful Excel Shortcuts

August 26, 2011

If you need to highlight all the data in a spreadsheet, CTRL + * does the trick.  Great for formatting, making a quick selection, etc.

If you need to copy a formula down many rows, you don’t have to copy/paste or use the fill handle to drag down.  Double click on the black dot in the lower right hand corner.  This works in the entire range where there is data to the left.

If you happen to have Excel 2010, you’ll notice a number of great new features.  One feature that I do like is that you can make a PDF of a file by clicking on File, Save As and selecting PDF as the format.  This is a great way to supply a client with a spreadsheet without showing the formulas or hidden/confidential sections of spreadsheet.

 

Advertisements

From → Excel

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: