Orientation buttons of Home tab Excel 2016

See Previous Post: Align buttons Alignment group Home tab Microsoft Excel 2016

The Alignment group is one of the important groups of the Home tab. In the previous post, we’ve discussed the Align buttons of this group. Some of those are the Top Align, the Middle Align and the Bottom Align etc; and so on. Also, this group has total Eleven buttons; including three more Align buttons.

They’re the Wrap Text, the Merge & Center, the Orientation etc. In addition, are the Decrease Indent and the Increase Indent buttons. In this post, we’ll focus ourselves on the Orientation buttons. This button is present at the sixth position, after the Align Right button at the top.

Orientation tools of Alignment group MS Excel – continued

So, there are Five type Orientation buttons; including the Format Cell Alignment. They’re the Angle Counterclockwise and the Angle Clockwise buttons etc. Also, the buttons are the Vertical Text, the Rotate Text up and the Rotate Text Down etc.

Firstly, the Angle Counterclockwise button helps to rotate the text, in the Counterclockwise direction in a cell. Secondly, the Angle Clockwise button is helpful to rotate the text, in the Clockwise direction. Thirdly, the Vertical Text button helps to arrange the text in vertical direction.

Orientation commands Home tab Excel 2016

Fourthly, the Rotate Text up button is helpful for rotating the text, in the upward direction in a cell. Further, the Rotate Text Down button helps to rotate the text, in the downward direction. Lastly, the Format Cell Alignment button shows the Format Cells dialog box window, when clicked.

Most noteworthy, also by using the Format Cells dialog Box, the texts get rotated. The Alignment tab present within this dialog box has the Orientation option with Degrees.

And, this dialog box further has many various options related to the rotation of texts. Also, the categories are the Text Alignment and the Text Control etc. Additionally, are the Right-to-Left and the Orientation with Degrees List Box.

See Next Post: Merge Center buttons Alignment group Microsoft Excel 2016

Align buttons of Home tab MS Excel 2016

See Previous Post: Border buttons description Font group Home tab MS Excel 2016

Now, a furthermore explanation about the Align buttons shall be given through this post. So, the Alignment group of the Home tab has Six Align buttons. In total, this group has Eleven buttons including the Six Align buttons. The buttons other than these Six are the Orientation, Decrease Indent, Increase Indent and the Merge & Center.

So, the Six Align buttons are the Top Align, Middle Align and the Bottom Align etc. In addition, are the Align Left, Center-Align and the Align Right buttons etc. Further, is some information that shall be remembered by the users.

First of all, the Text (Alphabets) when typed in a cell, by default shift to the left side cell border. Also, the Special Characters shift left side of the cell border. Secondly, the Numeric (Numbers) when put in a cell, by default shift to the right side border of the cell.

Using Align buttons of Alignment group Excel – continued

To understand the Align buttons, firstly select three Rows and set the Row Height to approx 50 (66 Pixels). And, then select three Columns and set the the Column Width to 15 (110 Pixels). So, now we have six cells which have Dimensions 50 X 15 of each one of them.

Type the Alphabet “A”  in all of the Six cells; starting from the Left Top Cell to the Right Bottom Cell. And, then click the First Left Top Cell and select the Top Align. Next, select the Second Middle Top Cell and click the Middle Align.

Likewise, then click the Right Top Cell and select the Bottom Align. In the same way, select the Align Left, Center-Align and the Align Right for the all the Bottom Cells respectively.

Notably, if we did all the steps correctly; the position of the character “A” shifted to Six locations within a cell. So, now by doing this, we’ve a clear understanding about the Align-buttons; when and where to use them appropriately.

See Next Post: Orientation buttons Alignment group Microsoft Excel 2016

Border buttons explanation Font group MS Excel

See Previous Post: Several ways use Format Painter worksheet Microsoft Excel 2016

So, once already, we’ve discussed about the Border buttons of the Font group. But, only an overview of the buttons were given, in one of the post. The Home tab has the Font group. Altogether, this group has total Ten buttons. Once again, now in this post, we’ll have a deep information about the buttons.

There are two categories in the Border button. One is the Borders category and the another one is the Draw Border category. So, the Border category has thirteen buttons. And, the Draw Border has six buttons.

In sum, there are total nineteen buttons. Especially, the buttons have an underscore under a specific letter. This is the Shortcut Key used with the Alt Key, which activates the particular specific button.

Border buttons of Font group Microsoft Excel – continued

First of all, the Border category buttons are the Bottom Border and the Top Border etc. Also, the Left Border, Right Border and the No Border etc. Additionally, the buttons are the All Borders and the Outside Borders etc.

In addition, the borders are the Thick Outside Borders and the Bottom Double Border etc. Further, are the Thick Bottom Border and the Top and Bottom Border etc. Then, the buttons are the Top and Thick Bottom Border and the Top and Double Bottom Border.

Secondly, the Draw Border category has the Draw Border; and the Draw Border Grid buttons etc. Also, the buttons are the Erase Border and the Line Color etc. Moreover, are the Line Style and the More Borders buttons.

The Line Color buttons further has the Automatic button. Also, it has the Theme Colors category, Standard Colors category and the More Colors button. Lastly, the Line Style button has various line design styles which is useful for the cell borders.

See Next Post: Align buttons Alignment group Home tab Microsoft Excel 2016

Numerous ways to use Format Painter MS Excel

See Previous Post: Different steps Paste data content spreadsheet Microsoft Excel 2016

In detail, we’ll discuss the ways to use Format Painter button in this post. This button is part of the Clipboard group. So, the Home tab ribbon has this group. Also, the Cut button, Copy button and Paste button are part of this group as well. But, we’ve to keep our focus on to the topic of this post.

The Format Painter tool applies any of the formatting types from one cell to another. Also, users can apply formatting to a range of cells. There are many types of Formats in Microsoft Excel. They’re the General format, Number format, Currency format and the Accounting format etc; and so on.

In addition, the Format Painter copies the formatting styles from one cell. And, then pastes it over on to another the cell or more than one cell. Also, the Format Painter tool can be doubled clicked. It means users can click twice on this button using the Left Mouse Click.

Various ways to use Format Painter Excel – continued

By this way, the tool becomes and remains active. So, to get rid of the Format Painter button, the “ESC” Escape shall be pressed. Notably, after this tool is double clicked, users can do multiple clicks throughout the sheet. So, How to use Format Painter ? Now, let’s know the multiple ways mentioned below on how to use this button.

Firstly, click on the cell, from which users might want to copy a format style or formatting type. Next, click on the Format Painter button once from the Clipboard group. By clicking this tool becomes active. And the Cursor changes to a Plus (+) with a Format Painter Brush icon. Then, click or drag a selection over on to another cell or group of cells to apply the format type.

Various ways to use Format Painter Microsoft Excel

Secondly, select the cell from which users like to copy the formatting style. Then, press the “Alt”, “H” and the “FP” keys altogether in sequence to activate the Format Painter button. Next, click on the desired cells and apply the selected formatting.

Thirdly, select the cell having the formats. Then, press the Copy button from the Clipboard group. Also, users can press the “Ctrl+C” Shortcut key to Copy the formatting from the cell.

Next, press the Menu Key/Application Key. A list dialog Menu of options will  show up. Then, click on to the another cell or click and drag a selection somewhere else. Now, press the “R” Key, to Apply the selected format.

See Next Post: Border buttons description Font group Home tab Microsoft Excel 2016

Many ways to Paste data or content Excel 2016

See Previous Post: Various ways Cut data content spreadsheet Microsoft Excel 2016

Different ways are there to Paste data or content in Excel. But, let us first of all know that, What is Paste ? Why to use Paste ? And, How to do Paste in Excel? Above all, Paste is initially inactive, and it becomes active after the Copy or Cut button has been pressed.

So, Paste is the last step for creating a Copy or Cut of any data, from one place to another. Also, the permanent shifting or cloning of data could be done using Paste. For example, it can be a Text, Number or any Picture etc. Users can Paste several amounts of the content, whether single or more than single.

The purpose of Paste is to create same actual copy of the content, to a new location in sheet. Notably, the Paste saves from retyping, also saves time, and sometimes makes space for the putting new data.

Moreover, the Pasting of data is done, in almost every software program. Further, the types of steps and the ways to Paste data in Excel 2016 have been mentioned below.

Numerous ways Paste data content MS Excel – continued

Firstly, click on the cell having text or number etc. Next, from the Clipboard group, click on the Copy or Cut button. Then, click anywhere on any of the cell in sheet. And, click the Paste button.

Secondly, click on the cell having content in it. Further, press the Right click Mouse button. A Menu list with various options will show up. And, now Left click on the Copy or Cut option from the Menu List. Then, next Right click with the Mouse button and select Paste option from the Menu List.

Thirdly, click on the cell having data in it. Next, use by pressing the Shortcut Key from the Keyboard i.e. (Ctrl+C) to Copy or (Ctrl+X) to Cut. Further, click on any other cell in the worksheet. And, press the Shortcut Key i.e. (Ctrl+V) to Paste.

Several ways to Paste data or content Microsoft Excel

Fourthly, select the cell which has the data. Also, users can select a range of cells having which has data. Further, press the Menu key or known as Application key. Next, press the “T” key from the Keyboard to Cut or “C” button to Copy. Then, click on any of the cell in the sheet. And, now press the Menu key and Press the “P” key from the Keyboard to Paste.

Even more, click on the cell which has the content. Then, Press the “Alt” key from the Keyboard to activate the Shortcut with Underscore keys. Next, Press the “H” key for the Home tab ribbon to activate.

Then, Press the “X” key to Cut or “C” key to Copy by activating any of these buttons. And, now click somewhere in the other cell in sheet. Lastly, Press the “Alt”, “H”, “V” and “P” keys to Paste.

See Next Post: Several ways use Format Painter Microsoft Excel 2016

Multiple ways to Cut data or content Excel 2016

See Previous Post: Multiple ways Copy data content workbook Microsoft Excel 2016

So, there are several steps to Cut data or content in Excel 2016. But, before discussing about those different ways, in the first place we shall know, What’s a Cut ? Why to use Cut ? And, How to do Cut in Microsoft Excel? 

Generally, Cut is a way of shifting the actual data from one place to another in Excel. For example, it is a Text, Number or any Picture etc; we could cut and move that data respectively. Hence, any amount of the data can be cut, whether it is single or more than single.

Above all, the purpose that Cut does is to change the actual place of the data. Also, by this way, Cutting data helps to create a blank space for the replacement with other new contents. Especially, the cutting of data is done, in almost every software program, other than Microsoft Excel. So, the steps and the types of ways to cut data in MS Excel have been given below.

Several ways to Cut data or content Excel – continued

Firstly, select the cell which has the data. Then from the Clipboard group, click on the Cut button. Further, click anywhere on any of the cell in sheet. And, click the Paste button.

Secondly, click on the cell which has the content. Then, press the Right click Mouse button. A Menu list with various options will show up. And, now Left click on the Cut option from the Menu List. Further, next Right click with the Mouse button and select Paste option from the Menu List.

Thirdly, click on the cell having text or number etc. Then, press the Shortcut Key from the Keyboard i.e. (Ctrl+X) to Cut. Next, click on any other cell in the worksheet. And, press the Shortcut Key i.e. (Ctrl+V) to Paste.

Many ways to Cut data or content Microsoft Excel

Fourthly, click on the cell having data in it. Also, Excel users can select a range of cells having data in them. Next, press the Menu key or known as Application key.

Then, press the “T” key from the Keyboard to Cut. Further, click on any of the cell in the sheet. Finally, now press the Menu key and Press the “P” key from the Keyboard to Paste.

Furthermore, click on the cell having content in it. Next, Press the “Alt” key from the Keyboard to activate the Shortcut with Underscore keys. Then Press the “H” key for the Home tab ribbon to activate.

And, now Press the “X” key to Cut by activating the Cut Button. Further, click somewhere in the other cell in sheet. Lastly, Press the “Alt”,  “H”, “V” and “P” keys to Paste.

See Next Post: Different steps Paste data content Microsoft workbook Excel 2016