Excel Tricks – Data

Transpose data from a row to a column, or vice-versa The best solution under the Paste Special menu. Start by selecting and copying your entire data range. Click on a new location in your sheet, then go to Edit | Paste Special and select the Transpose check box. Click OK, and Excel will transpose the … Continue reading Excel Tricks – Data

Excel Tricks- General

Excel Keyboard Shortcuts  Love your [Ctrl] key--for three reasons This three-fer will demonstrate why you should love and use your [Ctrl] key: Reason 1--Fast navigation. When you press [Ctrl] and any arrow key (north, east, south, or west), you jump to the last populated cell in that direction. Think of using the [Ctrl]-arrow key shortcut … Continue reading Excel Tricks- General