7 Awesome Excel Tricks And Treats

In this video, learn seven shortcuts and productivity tips to save time with Excel. These include horizontal scrolling, launch buttons for the Format Cells window, copying a sheet, clearing formats, copying down with the fill handle, stopping Excel from converting text to dates, and going dark on your office theme.

0:00 1. Horizontal Scrolling
1:01 2. Launch Buttons for the Format Cells Window
1:45 3. Copy a Sheet
2:10 4. Clear Formats
3:05 5. The Fill Handle
4:14 6. Preventing Excel from Converting Text to Dates
5:38 7. Dark Mode

Check out our full list with over 270 shortcuts for Excel and VBA.

Related Videos:

19 Advanced Excel Shortcuts (Do you know them all?):

7 Uncommon Excel Shortcuts to Teach to Your Coworkers:

My review of the Logitech MX Master mouse with horizontal scroll wheel:

#MsExcel #ExcelCampus

[sumardjo]

Thanks for knowledge
thanks for all
thanks

[ajRo_]

Hi Jon, Thank you for the Horizontal scrolling tip! This is a huge help, particularly when you need to screen share during virtual meetings on a small screen laptop! :)

[MasterWrench-M.O.S.Expert]

Hey Jon, Great as usual! I'm a student at The Professional Institute of Technology Inc. in Las Vegas, NV. Even though I have gone through the Excel courses, the information and shortcuts you provide are outstanding. Thank you & keep up the great work!

[Faritameus]

Hi Jon

Thank you so much for all that you do! Your channel is by far one of the most important and beneficial channels on YouTube.

I always go back to your channel if I ever got stuck with my reporting and / or recs as an AP Specialist.

Thanks for sharing your knowledge and expertise.

With Excel, there are several ways to skin the cat and it’s always good to learn more.

[MickyHunt]

Jon - so thankful for all you do. I really liked the adding the apostrophe for deterring Date Formatting. Does this impact using formulas in these cells? Thanks again!

[PaulEBrownbill]

Great as usual, especially like the tip about automatic dates and fill series. Useful tips.

[nadermounir]

Great tutorial Jon. Thank you sharing your knowledge with us :)

[wayneedmondson]

Hi Jon. Great tips! Another good one is ALT+PAGEDOWN for a page at a time to the right and ALT+PAGEUP for a page at a time to the left. Thanks for sharing :)) Thumbs up!!

[nixneato]

Thank you! Again an awesome video. I'm almost not mad you forgot to put the link to that Logitech mouse in the description... ;))

[DetLilleSmil]

1. One of my favorite shortcuts is Shift+Space and Alt+Space to select a whole row or column. When working inside a table, it selects just the row or column inside the table. Hit it again to include the header, and again to select the whole sheet row/column. 2. Ctrl and + or - to insert/delete rows/columns. 3. Hold down shift while dragging a row/column to insert it between two other rows/columns instead of replacing.

[teoxengineer]

Hi Jon,
Thank you for this tips. And, I wanna insert some small shortcuts additional with yours as below:
ALT+Shft+ ' = Formatting pannel (it is so useful to decrease duration of format options)
Using right click of mouse button while dragging for handling down cells (properties panel appears and it shows more options so quickly)

[scottgaines]

Great video! Thanks so much. I have that mouse and love it! :)

[onelac]

Help when I use the tab key on the key board it moves over to the next column the way it’s suppose to but if I hit tab again it returns to the home position and will not advance to the next column how do I get to advance next column and the next and so on

[kisho]

someone knows, how to render LaTex code in an Excel cell to be shown as mathematical formula?

[axelwangg]

Why I can't using Ctrl + Shift + scroll up/down for horizontal scrolling? is this only for 2016++ version?

[qlitzwice]

I need your help. I'm having trouble with the excel sheet. what I want to do is in column 1 there is a drop-down where it has the list of all departments, in column 2 I want a drop-down where all the names of all the employees who work on the department that I selected on column 1. how do I do that?

[shelbywoodard]

Excel 2016, professional office plus, holding ctrl+shift does not let me horizontal scroll. am I missing a setting somewhere?