hostresume.blogg.se

1. #Excel keyboard shortcuts 2010 how to
2. #Excel keyboard shortcuts 2010 update
3. #Excel keyboard shortcuts 2010 series

Tip: If you want to add several rows/columns at once time, for example, insert five rows/columns, select entire five rows/columns by clicking Ctrl key first, then press Ctrl + + keys or Shift + Ctrl + + keys, then new blank five rows/columns are inserted. If your keyboard has no Keypad, you can press Shift + Ctrl + + keys to insert rows or columns. Select an entire row/column that you want to add a row/column above or left of it, and then press Ctrl + + keys, then a new blank row/column added above/left of your selected row/column. But actually, you can easily use shortcut keys to quickly insert or delete row/column/tab as you need in Excel. In daily Excel working, to insert or delete a row or a column or a sheet tab is usually used. OK, that’s all I have to say (for now) about Excel keyboard (and other) shortcuts.How to use shortcut keys to insert or delete row/column/tab in Excel?

#Excel keyboard shortcuts 2010 series

See Part 1 of this series for an example. Use these shortcuts to navigate through sheet tabs in the current workbook. I use this to get more of a “full screen” effect in Excel (and when reading Word documents). This shortcut is simple enough it brings up the Print dialog / user interface. Just open a workbook and type this keyboard shortcut to trigger a “Refresh All”, which refreshes all external data connections. Select a cell in the range you want to filter:ĬTRL + ALT + F5 for Refresh All External Data

#Excel keyboard shortcuts 2010 how to

See this help topic for even more details on how to work with series AutoFill: Īs long as the active cell is in a range of data, typing this keyboard shortcut will turn on AutoFilter for that range, putting filter dropdown arrows at the first row of data. You can also fill a series of numbers using linear or growth progressions, as well as specify your own custom list to use as the basis for a fill. Try it yourself with your own values, or type Q1, or Q1FY09, or 1Q2009 and drag fill it down (grab the lower right corner of the selected cell and drag). Once you get to the end value you’re looking for, let go of the mouse:

#Excel keyboard shortcuts 2010 update

This will fill the Quarter number from 1 to 4 and then update the year that follows: There are also some handy series commonly used in finance that can automatically be filled in like 1Q2010. I type 1 in A1 and 2 in A2, select both cells, click and drag the fill handle down and now I have a numbered list as large as I need.Įxcel can automatically fill a large variety of series including the months, days of the week, dates, text, and formulas. One of the most common ways that I use it is to create a numbered list. While CTRL + F1 brings up the Number tab of the Format Cells, CTRL + SHIFT + F brings up the same dialog, but with the Font tab active.ĪutoFill is a really powerful feature that saves a lot of time typing repetitive series. If you wanted a chart sheet instead of a chart object on a worksheet, type F11 instead.

If you don’t like the default column chart that gets inserted, notice that on the Insert Chart dialog there is a button named “Set as Default Chart”, so all you need to do is pick the chart type you like and click that button:

I love this one – just highlight some data in the grid and type ALT + F1 to get a chart inserted onto the same sheet you’re working with. F12 or ALT + F, then A (if you like the file menu) will automatically bring up the Save As dialog.

But if you’re working on a workbook that’s already been saved, and now want to save it with a new name (sometimes I do that for versioning my work and maintaining backups of my progress), it’s useful to be able to quickly bring up the Save As dialog.

The Save As dialog will come up when typing CTRL + S as long as the book you’re working on has never been saved. Inserting more rows or columns (after the first insert, see Part 1 of this series for an example).Applying complex formatting to a cell (could also use the format painter).Use F4 to repeat the last thing you did, a great shortcut especially if the action just took several clicks. In Part 3 of my series on Excel shortcuts, I’m going to focus on a few miscellaneous shortcuts that help out with daily tasks. Today’s post is brought to you by Chad Rothschiller a Program Manager on the Excel team.