Quickie Tip: Select All Cells On A Worksheet

Written by Barbara in Excel Tips& Tricks,Quickie Tips

This is one of my favorite EVER timesaving Excel Tips

Need to quickly select all of the cells that contain data in your worksheet? This could be for formatting, or a a selection of data for a Pivot Table?

Hit CTRL+A —Bang they are all selected.

Want to select ALL the cellls on your entire worksheet

Hit CTRL+A again— Bang they are all selected.

Neat and sweet.

Here Are Some Other Excel Tips And Tricks You Might Like

1. Quickly Close Excel Worbook Or Excel Application

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts