To select
You can select cells and ranges in a table just like you would select them in a worksheet, but selecting table rows and columns is different from selecting worksheet rows and columns.
Need more help?You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice. See Also
Many marketers use Microsoft Excel every day, whether it's to create a chart, analyze data, or run a report to present at the next team meeting.
Creating reports like these in Excel is time-consuming enough. How can we spend a little less time navigating, formatting, selecting, and entering formulas for our data? Wouldn't it be great if there were keyboard shortcuts that could help us get our work done faster?
So glad you asked.
We’ve put together a list of 43 keyboard shortcuts for Microsoft Excel. Although you can do all of these maneuvers manually, knowing these tricks will help save you time so you can focus on the stuff that really matters.
All of these shortcuts can be accessed on PC and Mac, so we've included both types below where applicable.
(Note for Mac users: To access the F keys (F1–F12), you'll have to hold the Fn key before pressing any F key -- unless you've enabled those keys as standard function keys.)
43 Excel Shortcuts You'll Definitely Want to BookmarkNavigation Shortcuts
These simple shortcuts can help you navigate between workbooks, sheets, rows and columns:
Format Shortcuts
Formatting in Excel can be difficult if you don't know of what you're doing. Here are a few shortcuts that to help you easily format your cells. To start, here's a featured formatting shortcut you might not have known about:
Excel Strikethrough Shortcut
The Excel strikethrough shortcut will strike a line through the middle of the value or text in a highlighted cell. To strike a line through a cell, highlight the cell and press CTRL + 5 on your keyboard.
Here's what cells look like with (left) and without (right) a border:
Shortcuts for Selecting Rows & Columns
Save yourself the manual dragging and selecting rows and columns with these handy keyboard tricks. To start, here are two featured rows-related shortcuts you might not have known about:
Excel Insert Row ShortcutExcel Select Entire Column Shortcut Key
The insert row shortcut in Excel will create a new row below a highlighted cell. To insert a new row, highlight a cell or entire row and press CTRL + Shift + + on your keyword, literally pressing the plus sign after Shift. This will open a small window of options where you can insert a new row or column.
Formula Shortcuts
Formulas are a huge part of every marketer's Excel toolkit. Here are a few shortcuts that'll make you a formula wiz:
Miscellaneous Shortcuts
Here are a few more time-saving shortcuts. Shogun 2 rise of the samurai review. To start, here's a final featured shortcut for managing the size of your Excel worksheet:
Excel Delete Row Shortcut
The Excel delete row shortcut will delete the row below a highlighted cell. To delete this row, highlight a cell or entire row and press CTRL + - on your keyboard, literally pressing the minus sign after CTRL. This will open a small window of options where you can 'shift cells up.'
Want more Excel tips? Check out this list of common Excel error messages and how to fix them.
If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column. Unfortunately, I need to do this for 300,000 rows!
Is there a shortcut, similar to CTRL+SPACE, that will apply a formula to the entire column, or to a selected part of the column?
A-B-B
25.8k77 gold badges7171 silver badges7474 bronze badges
John ShedletskyJohn Shedletsky
2,88499 gold badges3030 silver badges5454 bronze badges
closed as off-topic by user2140173, Daniel A. White, kapa, Yogu, Martin SmithJun 30 '14 at 20:35
This question appears to be off-topic. The users who voted to close gave this specific reason:
3 Answers
Try double-clicking on the bottom right hand corner of the cell (ie on the box that you would otherwise drag).
soosoo
6,60011 gold badge1313 silver badges99 bronze badges
If the formula already exists in a cell you can fill it down as follows:
On Mac, use CMD instead of CTRL.
An alternative if the formula is in the first cell of a column:
25.8k77 gold badges7171 silver badges7474 bronze badges
robinCTSrobinCTS
4,94188 gold badges2121 silver badges3434 bronze badges
Select a range of cells (the entire column in this case), type in your formula, and hold down Ctrl while you press Enter. This places the formula in all selected cells.
PhilPhil
Not the answer you're looking for? Browse other questions tagged excelexcel-formula or ask your own question.
No need for VBA. I just need a keyboard shortcut.
I am trying to select the entire column minus the first 5 rows and do Format Cell.
I tried Ctrl + Shift + Down Array, but it takes me all the way to the bottom. It is hard to navigate back. Is there a better short cut ?
Lance Roberts
7,06488 gold badges4141 silver badges7676 bronze badges
thinkanotheronethinkanotherone
3 Answers
Use the Ctrl + Shift + ↓ (down arrow) that you suggest (starting at the 6th cell down in that column). Then, right click to select one of the cells at the bottom, and choose
Format Cells.. etc. When you apply the formatting the cursor will jump back to the top of the range (in Excel 2007 anyway).
As an aside, if you're at the bottom, you can hit Ctrl+Home to get back to jonscajonsca
A1 quickly.
3,7041414 gold badges3030 silver badges4545 bronze badges
Start at the bottom. For column A, for instance, select call A65536, press Ctrl + Shift + Up to get to cell A1, then still holding Shift, press Down five times.
Hand-E-Food
Excel Select Entire Column Shortcut WordHand-E-Food
4,45311 gold badge1313 silver badges3636 bronze badges
The easiest way is to select the cell in row 6, then press Ctrl+Shift+Down which will select the entire column except the first five cells. It takes you to the bottom, but all the cells you want are selected, so then do your right-click on the selection and choose format cells.
There's no need to go to the bottom first.
Does Grand Theft Auto 6 Game For PC allow to play online?Yes, this permits to play online, but you need high-speed network because this occupies more space. Gta san andreas download gratis para pc. You can see a different jeep here, but this is also beautiful and pretty and also perfect for such kinds of areas. This is not a demo, but highly compressed and latest and full version as well. Friends, the trailer is also released and if you want to watch that, then help from the videos websites. You can also from the same page and website.
Lance RobertsLance Roberts
7,06488 gold badges4141 silver badges7676 bronze badges
Excel Select Entire Column Shortcut Windows 10Not the answer you're looking for? Browse other questions tagged microsoft-excelkeyboard-shortcuts or ask your own question.
Below is a listing of most of the major shortcut keys and key combinations usable in Microsoft Excel. See the computer shortcuts page if you are looking for shortcut keys used in other programs.
Tip
To search for a specific item, modifier, or function, press Ctrl+F on your keyboard, type in keywords, and then click the up and down arrows to cycle through the options.
Additional informationComments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |