Excel Shortcut Keys: Using Ctrl + W (Closes the selected workbook window)

Excel Shortcut Keys

Ctrl + W
Closes the selected workbook window.

Excel Shortcut Keys: Using Ctrl + V (Inserts the contents of the Clipboard)

Excel Shortcut Keys

Ctrl + V
Inserts the contents of the Clipboard at the insertion point and replaces any selection.
Available only after you have cut or copied an object, text, or cell contents.

Excel Shortcut Keys: Using Ctrl + U (Underlining the text)

Excel Shortcut Keys

Ctrl + U
Applies or removes underlining.

Excel 2013 /16 Short Cut Keys: Alt + AE (Text to column)

Text to Column

Microsoft Excel 2013 Short Cut Keys:  Alt + A+E
Hit the Alt key. Then type AE (one key at a time).


Text to Column
Split a single column of text into multiple columns.
For example, you can separate a columns of full name into separate first and last name columns.
You can choose how to split it up: fixed width or split at each comma, period, or other character.

Shortcut Key : Excel (Ctrl + C)

Shortcut Key : Excel (Ctrl + C)

Put a copy of the selection on the Clipboard so you can past it somewhere else.

Copy Data and Past as Picture in Excel

Sometime we need the excel table in picture format and required to past the picture in Excel, Word, PowerPoint or Outlook.

Most of the people using the screen snap shot or using the print screen.

Here we can do this without using screen shot or something else

select your data you want to be convert to picture

Convert text to Capital-Case (Capitalizes all the letter in Text) in Excel

UPPER function

Capitalizes all the letter and any other letters in text that follow any character other than a letter in a text string. 

Syntax

UPPER(text)

The UPPER function syntax has the following arguments:

• Text    Required. The Text want converted to uppercase. Text can be a reference or text string

Example:

Type your data in C3 cell

and then type the proper function in cell G3

=PROPER(C3)

Here is the result