Excel Power Tips: 20 Tricks to help you become a Mouse Power User

// Recommended Excel Courses //

// Recommended Excel Templates //

If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.

They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!

// Show Notes //

Video Highlights:

--- Excel Ribbon Tricks ---
0:10 - Double click any Ribbon tab to toggle hide / show
0:50 - Use mouse scroll wheel to browse Ribbon menus

--- Working with Worksheets ---
1:23 - Double click worksheet tab to rename
2:00 - Right click to show worksheet list in current workbook
2:15 - Select multiple worksheets using SHIFT or CTRL keys

--- Locked Format Painter ---
4:00 - Double click to lock Format Painter tool (personal favorite)

--- Editing Long Formulas ---
5:30 - Working with long formulas
6:45 - Selecting whole words and sentences using double click trick

--- Fill Handle Tricks ---
7:15 - Basic fill handle dragging with left and right mouse buttons
7:48 - Double click fill handle to fill down to last row
8:18 - Fill a series of weekdays
8:30 - Fill a series growth trend (e.g. 1 2 4 8 16 32)

--- Cell Range Tricks ---
9:35 - F2 to edit formula then drag formula cell ranges
9:50 - Double click on cell border to move to furthest part of table
10:12 - Hold SHIFT key and double click on cell border to select to furthest part of table
10:22 - Hold SHIFT key and single click to select range
10:42 - Hold CTRL key and click to select non-contiguous range
11:10 - Copy formulas and paste as values using mouse only
11:48 - Exchange position of columns or rows using SHIFT + drag (personal favorite)

[emeritusesc]

Great video. Took me a while to figure out how you did the growth trend fill at minute 8:34, but as I was typing the question, I did it - right click instead of left click. That's great.

[launchexcel]

Hi emeritus 1esc - really happy that you liked the video. I made a big effort to collect the best mouse tips I could find and present them in a way that lots of people could learn from.

[MarkCBB]

wow, there where a few things I did not know about, thanks for making the video!

[jamesperry]

GREAT VIDEO! AND ALL GREAT TIPS. THE VIDEO SI GONNA HELP ME A LOT. KUDOS!

[marianandsunrisesmiles]

Thank you for tutorial videos, it’s a great help.

[launchexcel]

Using Screenflow for Mac, recorded the Windows portion via VMWare Fusion. I think Camtasia for Windows/Mac does cursor size changes too.

[MsSkyview]

Thank you for making this video, it is brilliant.

[donidorirecica]

WOW ITS AN AMAZING VIDEO! THANK YOU DUDE!

[kristinlee]

this was amazing, thank you!! I've always known there had to be a way to do that with format painter. Now I know!!

[sosonay]

Amazing I only knew one of them and the rest are new

[cheesedoodle]

can you share the excel file you used in the tutorial?

[goldau]

how to create a series of numbers in the cell by providing the one number,
example if i write a number 13 in the cell it shows the series in 1to13, for cell 1, second 13

[abhisekmaroti]

a cell consists of the following data - "04-11-2015 00:00 - Amendment [5344867]"
i want to pull out only "amendment" text out from it. How can i do so?