- Several Users Work on the Same Workbook Together!
If you have several users who need to work from the same workbook at the same time, familiarize yourself with Excel’s Shared Workbook feature. This feature can be a lifesaver when workbooks must be updated by multiple users.
You can set options that control when changes are updated and how to handle conflicting edits by different users. You can also choose to save updates when a user clicks Save, or you can specify a time interval for Excel to automatically save user updates.
To use this feature:
-
- From the Tools menu, click Share Workbook.
- From the Share Workbook dialog box displayed, in the Editing tab, check Allow changes by more than one user at the same time option.
- Click the Advanced tab and do the necessary settings.
You can decide how changes should be logged by the Track Changes feature, which integrates with workbook sharing. That way, you can see exactly what changes were made to cells, when sheets were added or deleted, how conflicting edits were resolved, etc. Users can also see the names of all the other users who have the workbook open for editing.
- Transpose data from a row to a column, or vice-versa
Suppose you’ve entered your data with three column headings running across Row 1 and three row headings running down Column A.
After working with the data for a while, you decide you’d rather have the current set of row labels (months) running across the columns. If its a short data its easy to retype, but think of large data..
You’ll find 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.
- [Ctrl] key Features
- 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 row of a data set or pressing [Tab] to find the last column.
- You can make noncontiguous selections. That’s a fancy way of saying you can select any cells you want, regardless of whether they’re contiguous–next to each other in a row or column. Hold down the [Ctrl] key while you click on a cell or click and drag through a range of cells. As long as you hold down the [Ctrl] key, you can click and select to your heart’s content.
- Fast data entry. Suppose you want to put the same string, number, or formula into two or more cells. Using the old-fashioned approach, you’d type the string, number, or formula into the first cell and then copy and paste that entry into the destination cells. But there’s a little-known time-saving tip that makes short work of placing the same entry in multiple cells. First, select all the cells you want to populate. Type the entry, but don’t press [Enter]. Instead, press [Ctrl][Enter]. When you do, Excel will copy what you typed into all of the selected cells.
- Double Click Features
- Double Click on the Office Button / Logo to Close Excel
- Adjust column widths by selecting multiple columns and double clicking on the separators
- Double-click in the corner, just above scroll-bar to include a split
- Double click on ribbon menu names to collapse ribbon to get more space
- Auto-fill a series of cells with data or formulas by just double clicking
- Jump to last row / column in table with double-click
- Lock a particular feature and reuse them with double-click
You can lock any repeatable feature (like format painter, drawing connectors, shapes etc.) by just double clicking on the icon (in Excel 2007 this works for format painter, but for drawing shapes you need to right click and select lock drawing mode).
If you know any more features, feel free to add in the comments and if you liked this article, please spread it… 
Related posts:
