Most of our job profiles require us to use Excel features in
the most comprehensive ways which would give us meaningful yet effective results
as soon as possible.
Right click and select Copy menu option.
Right click and choose “Paste Special” menu option. In the
Paste Special dialog box that appears, select the checkbox, Transpose, and
click on OK button.
Ctrl + PageDown (Key) - Move right of the Excel Worksheets tabs from the current active worksheet
I had many such situations which required me to find out the
easiest and the most effective ways to do our tasks in Excel 2007. I would be
henceforth giving a step by step approach for few such features :
Requirement : How to change columns cell values into row
cell values ? (It is called transpose)
How to Do ?
Select the full range of column cell values.
Place the focus on any blank cell where you want the range
of cell values to be pasted in the form of row cell values.
Note that the column cell values has been pasted into row
cell values
Requirement : To traverse through the Excel worksheets tabs
via Keyboard shortcut key ?
How to do ?
Most of us would use the mouse for traversing through the
Excel Worksheets tabs. Keep focus on any of the Excel worksheet cell and then
use the following keyboard shortcuts :
Ctrl + PageUp (Key) - Move left of the Excel Worksheets tabs
from the current active worksheetCtrl + PageDown (Key) - Move right of the Excel Worksheets tabs from the current active worksheet
No comments:
Post a Comment