filmov
tv
3 Quick & Easy Excel Tips
Показать описание
3 quick tips for Microsoft Excel that will help speed up your workflow. Quickly select cells.
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
Affiliate Links:
PC-Addicts Google+ Community Page:
PC-Addicts on Pinterest:
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
Affiliate Links:
PC-Addicts Google+ Community Page:
PC-Addicts on Pinterest:
0:00:52
🧙♂️ 5 BEST Excel Shortcuts
0:00:59
How To Fill Numbers In Excel Quickly And Easily!
0:24:25
Microsoft Excel Tutorial - Beginners Level 3
0:08:56
Three EASY Ways to Find and Remove Duplicates in Excel
0:00:21
Select 10000 Cells in 1 Second in Excel #excel #msexcel #exceltips #exceltutorial #microsoftexcel
0:00:37
Copy And Paste Excel Sheets Faster With This Shortcut!
0:09:19
Excel Quick and Simple Charts Tutorial
0:27:19
Top 10 Most Important Excel Formulas - Made Easy!
0:00:58
Master Excel Data Forms Easy Steps
0:01:00
3 Excel Interview Questions in 60 seconds #shorts
0:00:53
3 Amazing Excel Features… most people don't know
0:10:47
Excel Formulas and Functions You NEED to KNOW!
0:54:55
Excel for Beginners - The Complete Course
0:02:47
How to Multiply Numbers in Excel (Basic way)
0:14:04
10 Best Excel Tips for Beginners
0:06:22
SUPER EASY Excel Data Entry Form (NO VBA)
0:03:42
How to Create a Table in Excel (Spreadsheet Basics)
0:00:44
Excel Quick Tips - How to create a data table using keyboard shortcuts
0:00:51
How to AutoFit EVERYTHING in Excel FAST! #shorts
0:25:38
Top 20 Microsoft Excel Tips & Tricks
0:00:25
Copy Data Fast in Excel! 🤩 #shorts
0:02:58
How to use the VLOOKUP function in Excel
0:15:54
Excel Tutorial for Beginners | How to Use Excel
0:03:33
Xlookup In Excel: Explained In 3 Minutes
Комментарии