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