EXCEL : Rename a Sheet Using Double Click

There are multiple ways to rename sheets, and most users will right click to choose Rename, which actually wastes a lot of time. The best way is to just click twice, then you can rename it directly.

For more click here

Read More »

EXCEL : One Click to Get More Status

Most users know how to check the data status in the bottom of an Excel sheet, like Average and Sum Value. However, do you know you can move the pointer to the bottom tab and right click to get more status, as shown below?

For more click here

Read More »

EXCEL : Speed up Inputting Complicated Terms with AutoCorrect

If you need to repeat the same value and it is complicated to input, the best way is to use the AutoCorrect function, which will replace your text with the correct text. Take my name, Liza Brown, for example, which can be replaced by LZ. Therefore, every time I input LZ, it can autocorrect to Liza Brown. Go to File->Options->Proofing->AutoCorrect Options and input Replace text with correct text in the red rectangular area, as below.

For more click here

Read More »

EXCEL : Add More Than One New Row or Column

You may know the way to add one new row or column, but it really wastes a lot of time if you need to insert more than one of these by repeating this action X number of times. The best way is to drag and select X rows or columns (X is two or more) if you want to add X rows or columns above or left. Right click the highlighted rows or columns and choose Insert from the drop down menu. New rows will be inserted above the row or to the left of the column you first selected.

For more click here

Read More »

EXCEL : Transpose Data from a Row to a Column

You would use this feature if you want to transpose data to get a better display; however, retyping all data would be the last thing you would need to do if you know how to use the Transpose function in Paste. Here’s how: copy the area you want to transpose, move the pointer to another blank location. Go to Home->Paste->Transpose, please note that this function won’t activate until you copy the data first.





For more click here

Read More »

EXCEL:Create a New Shortcut Menu

Generally there are three shortcuts in the top menu, which are Save, Undo Typing and Repeat Typing. However, if you want to use more shortcuts, like Copy and Cut, you can set them up as follows:

File->Options->Quick Access Toolbar, add Cut and Copy from the left column to the right, save it. You will see two more shortcuts added in the top menu.

For more click here

Read More »

EXCEL : Compose Text with &

Complicated formulation is unnecessary, as long as you know how to use &. You can compose any text freely with this symbol. Below I have four columns with different texts, but what if I want to compose them to one value in one cell? First, locate the cell that is to show the composed result, use the formulation with & as shown in the screenshot below. Click Enter: all texts in A2, B2, C2 and D2 will be composed together to become LizaUSA25@ in F2.

For more click here

Read More »

EXCEL : One Click to Select All

You might know how to select all by using the Ctrl + A shortcut, but few know that with only one click of the corner button, as shown in the screenshot below, all data will be selected in seconds.

For more click here

Read More »

SAS :Keyboard Shortcuts within Print Preview

Action	Keyboard Shortcut
Next page or Page Down	Alt + N
Previous page or Page Up	Alt + P
Zoom	Alt + Z
Help	Alt + H
Print	Alt + R
Close the window	Alt + C or
	Alt + F4

For more  Click Here

Read More »

SAS : Keyboard Shortcuts within the SAS Main Window

Category	Key Combination	Action
Dialog Boxes and Entry Fields	Tab	move to next field
	Shift + Tab	move to previous field
	Navigate around Text
	Ctrl + -> (right arrow)	move to next word
	Ctrl + <- (left arrow)	move to previous word
	Home	move to beginning of line
	End	move to end of line
	Ctrl + Home	move to top
	Ctrl + End	move to bottom
	Page Up	page up
	Page Down	page down
	Ctrl + Page Up	move to top
	Ctrl + Page Down	move to bottom
	Ctrl + Tab	navigate to the next open SAS window (NEXTWIND command)
	Ctrl + Shift + Tab	navigate to the previous open SAS window (PREVWIND command)
Mark Text	Shift + -> (right arrow)	mark while going to the right
	Shift + <- (left arrow)	mark while going to the left
	Shift + Home	mark to beginning of line
	Shift + End	mark to end of line
	Shift + Ctrl + Home	mark to top
	Shift + Ctrl + End	mark to bottom
	Shift + Page Up	page up and mark
	Shift + Page Down	page down and mark
	Shift + Ctrl + Page Up	mark to top
	Shift + Ctrl + Page Down	mark to bottom
	Shift + MB1	extend the current marked text selection to the click position
Cut, Copy, and Paste	Delete	delete the next character (or marked text)
	Ctrl + Delete	delete from the insertion point position to the end of the current word
	Ctrl + Backspace	delete from the insertion point position to the start of the current word
	Ctrl + MB1	selects the entire line (clicked line)
	Ctrl + Z	undo previous action
	Ctrl + X	cut selected text
	Ctrl + C	copy selected text to paste buffer
	Ctrl + V	paste text
Window Control	Alt	switch focus to or from the main menu bar
	Shift + F5	cascade the windows
	Shift + F4	tile the windows vertically
	Shift + F3	tile the windows horizontally
	Ctrl + F6	next window
	Alt + F4	exit SAS
	Ctrl + F4	close the active window
	Ctrl + W	access new SAS explorer window
	Shift + F10	open pop-up menu
Resizing the Docking View	Alt + W + S	start docking view resizing
	-> (right arrow)	move the split bar a small amount to the right
	<- (left arrow)	move the split bar a small amount to the right
	Ctrl + -> (right arrow)	move the split bar a larger amount to the right
	Ctrl + <- (left arrow)	move the split bar a larger amount to the left
	Home	move the split bar all the way to the left
	End	move the split bar all the way to the right
	Return	accept the current size of the docking view and exit docking view resizing
	Esc	end docking view resizing without resizing the docking view
	Miscellaneous
	Alt + Enter	open the Properties dialog box for a selected object
		This command is valid only in a Tree view or a List view.
	Esc + letter (or number)	color or highlighting attributes in NOTEPAD window

for more Click here

Read More »

SAS :Keyboard Shortcuts within the Enhanced Editor

Category	Command	Keyboard Shortcut
Abbreviation	Add a new abbreviation	Ctrl + Shift + A
	Bring up word tip	Alt + F1 + No Selection
	Hide the current word tip	Esc
Code Collapsing	Collapse all tiered blocks	Alt + Ctrl + Number pad -
	Collapse current line	Alt + Number pad -
	Expand all tiered blocks	Alt + Ctrl + Number pad +
	Expand current line	Alt + Number pad +
	Toggle expand current line	Alt + Number pad *
Command and Macro Support	Add or change macros	Ctrl + Shift + M
	Execute the last recorded macro	Ctrl + F1
	Play a command and macro	Alt + F8
	Start and Complete macro	Alt + Shift + R
Edit	Copy selection	Ctrl + C
		Ctrl + Insert
	Cut selection	Ctrl + X
		Shift+Delete
	Delete current character	Delete
	Note: You can delete the entire line by using SHIFT+END to extend the selection to the end of the line and pressing the delete or backspace key.
	Delete previous character	Backspace or Shift + Backspace
	Delete to next word start	Ctrl + Delete
	Delete to previous word start	Ctrl + Backspace
	Insert a carriage return	Enter
	Paste from clipboard	Ctrl + V
		Shift+Insert
	Redo	Ctrl + Y
		Alt + Shift + Backspace
	Undo	Ctrl + Z
		Alt + Backspace
Help	Get Help for a SAS procedure	place the insertion point within a procedure name and press F1
	Context Help	F1
Line Markers	Go to the next marked line	F2
	Go to the previous marked line	Shift + F2
	Toggle marker on the current line	Ctrl + F2
Navigation	Go to line (interactive)	Ctrl + G
	Move cursor to the top of the file	Ctrl + Page Up
		Ctrl + Home
	Move cursor to the bottom of the file	Ctrl + Page Down
		Ctrl + End
	Move cursor down	Down
	Move cursor down a page	Page Down
	Move cursor left	Left
	Move cursor right	Right
	Move cursor to beginning of line	Home
	Move cursor to end of line	End
	Move cursor to matching brace and parentheses	Ctrl + [
		Ctrl + ]
	Move cursor to matching DO and END keyword	Alt + [
		Alt + ]
	Move cursor to next case change	Alt + Right
	Move cursor to next word start	Ctrl + Right
	Move cursor to previous case change	Alt + Left
	Move cursor to previous word start	Ctrl + Left
	Move cursor up	Up
	Move cursor up a page	Page Up
	Move cursor to the first visible line	Alt + Up
	Move cursor to the last visible line	Alt + Down
	Scroll screen down	Ctrl + Up
	Scroll screen up	Ctrl + Down
Option Setting	Toggle insert and overwrite mode	Insert
Selection	Extend selection character left	Shift + Left
	Extend selection character right	Shift + Right
	Extend selection down	Shift + Down
	Extend selection down a page	Shift + Page Down
	Extend selection to beginning of document	Ctrl + Shift + Home
		Ctrl + Shift + Page Up
	Extend selection to beginning of line	Shift + Home
	Extend selection to end of document	Ctrl + Shift + End
		Ctrl + Shift + Page Down
	Extend selection to end of line	Shift + End
	Extend selection to next case change	Alt + Shift + Right
	Extend selection to previous case change	Alt + Shift + Left
	Extend selection up	Shift + Up
	Extend selection up a page	Shift + Page Up
	Extend selection to previous word start	Ctrl + Shift + Left
	Extend selection to the next word start	Ctrl + Shift + Right
	Select all	Ctrl + A
Selection Operations	Clean up whitespace characters	Ctrl + Shift + W
	Comment the selection with line comments	Ctrl + /
	Convert the selected text to lowercase	Ctrl + Shift + L
	Convert the selected text to uppercase	Ctrl + Shift + U
	Tab selection	Tab + Selection
	Undo the Comment	Ctrl + Shift + /
	Left Tab selection	Shift + Tab + Selection

for more Click Here

Read More »