#autocalculate

[aalberici]

Excel Tricks - Data

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 column and row labels and data.

Convert calculations to literal values

This jewel, like #9, is…

View On WordPress

[aalberici]

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 as an alternative to pressing [Page Down] to find the bottom…

View On WordPress

[graphic-river]

Invoice Bundle 5593685

(more…)

View On WordPress