June 13, 2011 - Posted by yaya - 0 Comments
One of my biggest headaches is simply the fact that I own too many blogs. There is the semi-interesting one used for occasionally reflecting on Internet articles and events; there is the dark and emo one used for ranting all personal issues; there is the upbeat and inspirational one used for personal management and motivation; there are the odd few others ones scattered across the Internet, all containing random musings.
Pulling out my old web design folders yields several blog designs - some make me cringe, some make me smile. Oh, what to do with you all?
May 25, 2011 - Posted by yaya - 0 Comments
Pasted and compiled a list of MS Excel shortcuts. Common shortcuts have been omitted:
A. Basic Navigation
Ctrl + Space
Shift + Space
Ctrl + Arrow
Ctrl + Page Up
Ctrl + Page Down
Ctrl + Home |
Select column
Select row
Moves cursor along series of cells
Cycles through worksheets
Cycles through worksheets
Selects A1 on current worksheet |
B. Advanced Navigation
Ctrl + Shift + (
Ctrl + Shift + *
Ctrl + Shift + (+)
Ctrl + Shift + (-)
Ctrl + G
Ctrl + L
Ctrl + T
F3
Shift + F3
F4
F5
F6
F8
Shift + F8
Ctrl + F8
Ctrl + F9 |
Unhides any hidden rows
Selects the current region around the active cells
Displays insert dialog box
Displays delete dialog box
Displays the go to dialog box
Displays the create table dialog box
Displays the create table dialog box
Displays the paste name dialog box
Displays the insert function dialog box
Repeats the last command or action, if possible
Displays the go to dialog box
Switch between the worksheet, ribbon, task pane, and zoom controls
Turns extend mode on or off
Enables adding a nonadjacent cell or range using arrows
Performs size command when workbook not maximized
Minimizes a workbook window into an icon |
C. Basic Formatting
Ctrl + 1
Ctrl + Shift + ~
Ctrl + Shift + $
Ctrl + Shift + %
Ctrl + Shift + ^
Ctrl + Shift + #
Ctrl + Shift + @
Ctrl + Shift + ! |
Displays the format cells dialog box
Applies the general number format
Applies the currency format with two decimal places
Applies the percentage format with no decimal places
Applies the scientific number format with two decimal places
Applies the date format with day, month, and year
Applies the time format with the hour and minute, and AM or PM
Applies the number format with two decimals, thousands separator |
D. Advanced Formatting
Ctrl + Shift + &
Ctrl + Shift + _
Ctrl + ` |
Applies the outline border to the selected cells
Removes the outline border from the selected cells
Alternates between cell values and cell formulas |
E. Functionalities
Ctrl + Shift + :
Ctrl + ;
Ctrl + Shift + “
Ctrl + ‘
Ctrl + D
Ctrl + R
F9
Shift + F9
Ctrl + Alt + F9 |
Enters the current time
Enters the current date
Copies the value from the cell above the active cell
Copies a formula from the cell above the active cell
Uses the fill down command to copy the content and format of the topmost cell
Uses the fill right command to copy the content and formats of the leftmost cell
Calculates all worksheets in all open workbooks
Calculates the active worksheet
Calculates all worksheets regardless of last calculations |
