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- Formula and Function

What's the Current Date or Time? You may be familiar with Excel's NOW function, which plugs the current date and time into your spreadsheet. Just enter¬†=NOW()¬†into any cell, and Excel displays the date and time formatted according to the regional options you've set for Windows. If you just want to see the date, use the … Continue reading Excel Tricks- Formula and Function