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

Convert text to Initial-Case (Capitalizes the first letter in Text) in Excel

PROPER function

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

Syntax

PROPER(text)

The PROPER function syntax has the following arguments:

• Text    Required. Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.

Example:

Type your data in C3 cell

and then type the proper function in cell G3

=PROPER(C3)

Here is the result

Text

In literary theory, a text is any object that can be "read," whether this object is a work of literature, a street sign, an arrangement of buildings on a city block, or styles of clothing. It is a coherent set of signs that transmits some kind of informative message. This set of symbols is considered in terms of the informative message's content, rather than in terms of its physical form or the medium in which it is represented.

Within the field of literary criticism, "text" also refers to the original information content of a particular piece of writing; that is, the "text" of a work is that primal symbolic arrangement of letters as originally composed, apart from later alterations, deterioration, commentary, translations, paratext, etc. Therefore, when literary criticism is concerned with the determination of a "text," it is concerned with the distinguishing of the original information content from whatever has been added to or subtracted from that content as it appears in a given textual document (that is, a physical representation of text).

Since the history of writing predates the concept of the "text", most texts were not written with this concept in mind. Most written works fall within a narrow range of the types described by text theory. The concept of "text" becomes relevant if/when a "coherent written message is completed and needs to be referred to independently of the circumstances in which it was created."

Source: