3 Quick & Easy Excel Tips

3 Quick & Easy Excel Tips

3 quick tips for Microsoft Excel that will help speed up your workflow. Quickly select cells. Details and instructions: http://bit.ly/1TZOthE

Three basic spreadsheet tips and tricks I use all of the time that help speed up my workflow.
Again, these are 3 BASIC tips, not advanced!

Subscribe (both here on the site and YouTube) to keep up to date when new Excel tips and tricks videos will be published!

3 Basic Excel Spreadsheet Tips
Tip #1

Auto-fill an entire column by clicking and dragging

Example: You have a column you need dates populated in
Select the first cell in the column
Click and hold the square in the bottom-right of the selected cell
Drag down until you want the dates to stop
Tip #2

Auto-fill an entire column by double-clicking

Same example as Tip #1
Select the first cell in the column
Double-click the square in the bottom-right of the selected cell
Tip #3

Quickly select entire column, row, or both

Example: You want to select all cells that have data
Assuming there are no blank rows
Select the top-left most cell
Hold CTRL+SHIFT
Press the down-arrow (this will select all rows in the column)
While holding CTRL+SHIFT still, press the right-arrow (this will select all columns

Subscribe for more videos: http://bit.ly/1La0Chu

PC-Addicts Website:
http://pc-addicts.com

PC-Addicts FaceBook Page:
http://bit.ly/1TDJ6oX

PC-Addicts Twitter:
http://bit.ly/1StCtDY

PC-Addicts Google+ Community Page:
http://bit.ly/21gyYkF

PC-Addicts on Pinterest:
http://bit.ly/1QFmjmq

Leave a Reply

Close Menu