|
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | VBA | | | SharePoint | | | Consultancy | | | Newsletter | | | Contact |
| Excel > Rows & Columns | < Previous | Next > |
Basic |
| Expand | - | Getting Started |
| Step By Step | - | Selecting Data |
| Step By Step | - | Moving Data |
| Step By Step | - | Column Widths |
| Step By Step | - | Row Heights |
| Step By Step | - | AutoFit Selection |
| Step By Step | - | Inserting Data |
| Step By Step | - | Deleting Data |
| Step By Step | - | Hiding Data |
| Step By Step | - | Freeze Panes |
Advanced |
| More Details | - | Outlines |
| More Details | - | Insert Options Smart Tag |
| More Details | - | Advanced Techniques |
| More Details | - | Office Online |
| More Details | - | Knowledge Base |
| More Details | - | Knowledge Base - Numerical |
| More Details | - | Excel 2007 |
| More Details | - | Excel 2010 |
| More Details | - | VBA Code |
Shortcut Keys |
(Home) - Moves to column "A" in the current row. | ||
(Shift + Spacebar) - Selects the current row (only works for a continuous block). | ||
(Ctrl + Spacebar) - Selects the current column (only works for a continuous block). | ||
(Ctrl + 9) - Hides the rows in the current selection. | ||
(Ctrl + 0) - Hides the columns in the current selection. | ||
(Ctrl + Shift + 9) - Unhides the rows in the current selection. | ||
(Ctrl + Shift + 0) - Unhides the columns in the current selection. | ||
(Ctrl + Shift + =) - Inserts rows (or columns) above the current selection (rows or columns must be selected first). | ||
(Ctrl + -) - Deletes rows (or columns) currently selected (rows or columns must be selected first). |
Related Topics |
| GoTo | - | Cells & Ranges |
| GoTo | - | Tables |
| Copyright © 2011 Better Solutions Limited. All Rights Reserved. | Top |