The top 25 Excel shortcut tips and tricks.
These are not ordinary shortcuts. Here are some surprising shortcut tips and
tricks that can save you a bunch of time in Excel. #1 Paste Values.
This is the quickest method to pasting values. Highlight the area you want to copy, hit Ctrl-C,
go to your new location, right-click, and push V. It's that simple.
#2 Insert Selection. Select an area of your spreadsheet. Go to the edge and
hold the Shift key down while you click on the left mouse button. Drag it to a new location
and let go. That inserts the selection in that new location. You can do it for an entire row
or you can do it for an entire column.
#3 Copy Selection. You can also do something similar to that by copying the selection.
Highlight a selection, go to the corner, hold down the Ctrl key while you left click
and drag and drop it to copy that selection to the new location. #4 Show Formulas. You can toggle the
formulas on and off in your spreadsheet by hitting the Ctrl-`. That's on the key with the tilde
and it gives you a way to view the formulas being used within your spreadsheet.
#5 Flash Fill. You can easily replicate patterns of data with Ctrl-E. Let's say we wanted to take
the first name and the type and put it into this column E. If we fill out the first one
and hit enter you can just press Ctrl-E and it will copy the remaining patterns down the list.
#6 Quick Sum. If you want to quickly sum up a list of numbers click on your location where you want
the total, hit Alt-=, and Enter. There's your Sum. #7 Insert Date or Time. Click on a cell,
hit Ctrl-; to insert the date. Hit Ctrl-Shift-; to insert the time. #8 Zoom In or Out. You can
zoom in and out on your spreadsheet by holding down the Ctrl key and using the mouse wheel.
You can do the same thing by holding Ctrl-Alt and hitting plus or minus.
#9 Autosize Columns and rows. You can automatically resize the width of the columns
and the height of the rows to match the data. Just click in the upper left corner to select all your
data in your spreadsheet, double-click on the line between a column, and it adjusts the width of all
the columns. Double-click between the rows and it adjusts the height of all the rows. #10 Select
Column or Row. Click anywhere in your spreadsheet and hit Ctrl-Spacebar to select the column.
Shift-Spacebar to select the row. You can do the same thing by clicking on the column header up
here or the row header. #11 Create Chart. Select a set of data and hit Alt-F1 to create a chart.
You can hit F11 and it creates the chart on a separate worksheet.
#12 Cell References. If you have a formula you can click anywhere inside of the cell reference
and hit F4 to rotate between column and row cell referencing. Highlight an entire formula
and it changes all the references. #13 Add Notes. If you want to add notes to a cell
just click on it and hit Shift-F2, type in your notes, and they're stored with that cell.
Come back there and it displays them. If you right-click you can delete the note. #14
Hide Column or Row. You can quickly hide a row by hitting Ctrl-9. Hide a column with Ctrl-0.
#15 Filter. Click anywhere in the heading of a table and hit Ctrl-Shift-L. That turns on the
filtering and it does it for all the columns in that table. Hit it again and it turns them off.
If you highlight the columns that you want it turns it on just for those columns
and again to turn it off. #16 Select Region.
If you want to quickly select a region just click anywhere inside and hit Ctrl-Shift-Spacebar.
#17 Formatting. You can bring up the formatting cell window by hitting Ctrl-1 but you can also
assign these categories of formats directly with the Ctrl-Shift and a key. For example,
Ctrl-Shift-` gives you the General format.
Ctrl-Shift-1 is the Number format. Ctrl-Shift-2 is the Time. Ctrl-Shift-3 is the Date. Ctrl-Shift-4
is Dollar formatting. Ctrl-Shift-5 is Percent. Ctrl-Shift-6 is Scientific.
#18 Copy Down or Right. If you want to copy data down from the cell above it hit Ctrl-D.
This also works by highlighting a whole range.
If you want to copy to the right hit Ctrl -R and it works across a range as well.
#19 Table. If you want to name a table just highlight your range, hit Ctrl-T,
hit OK on the selection, and you can change the name right here.
#20 Apply or Remove Border. You can add a border to a group of cells. Just highlight them and hit
Ctrl-Shift-7. That adds a border. Ctrl-Shift-Minus removes the border.
#21 Workbook Statistics. From anywhere on your screen you can hit Ctrl-Shift-G
to bring up statistics about your workbook. It includes the number of tables and formulas
and the total number of cells with data in them.
#22 Expand Selection. If you want to expand the area you have selected hit Ctrl-Shift-Right Arrow
or Ctrl-Shift-Down Arrow and it will expand until the next gap in data. #23 Insert Multiple Rows.
Start on the row that you want to insert above, select multiple rows, in this case four,
right-click, choose Insert, and it inserts four rows. Same thing works with columns.
#24 See Formula Results. While you're inside of a cell with a formula you can highlight a portion of
the formula, hit F9, and it gives you the results of that calculation. If you hit Ctrl-Z it reverts
it back. I can select the entire formula, hit F9, and get the entire result. Ctrl-Z reverts it back.
#25 Quick Analysis. If you highlight a table of data in the bottom right
corner is a Quick Analysis Tool. If it's not there you can hit Ctrl-Q and it'll come up.
Here you can select all kinds of different settings for formatting, creating charts,
adding totals,
converting your data into tables, and adding sparklines.
That's the top 25 Excel shortcut tips and tricks.
Start using them today to improve your efficiency using Excel.
Hey, if you want to see more videos like this one please subscribe and if you've enjoyed this video
be sure to click the thumbs-up and leave a comment. I really do appreciate your support!