Cells group buttons overview Microsoft Excel

See Previous Post: Styles group buttons tools Home tab Microsoft Excel 2016

So, the Insert, the Delete and the Format buttons are part of the Cells group. This group of the Home Tab ribbon holds the sixth position. Hence, as discussed earlier in the posts, like the Styles group; the buttons in the Cells-group also have Drop down list menu.

Also, adjusting of the Height & Width with help of the buttons of this group. Additionally, we could do the Insertion of Row and Column. Even more, the Deletion of Rows & Columns and the Renaming Sheets as well.

Especially relevant, the shortcut for Inserting Row is Ctrl+”+” buttons, neglecting the inverted commas. Similarly, the shortcut for Deleting Row is Ctrl+”-” buttons. Same shortcuts are for the Column as well.

Especially, tools like Insert Cells, Insert Sheet Rows, are part of Insert button. And, also are the Insert Sheet Columns and Insert Sheet buttons too.

Then, the Delete Cells and the Delete Sheet Rows buttons etc; are part of the Delete button. In addition, the buttons are the Delete Sheet Columns and the Delete Sheet buttons.

Cells group commands MS Excel 2016 – continued

Further, the Cell Size category within Format button has the Row Height, AutoFit Row Height buttons etc. Moreover, the Column Width, AutoFit Column Width, Default Width falls under Cell Size category.

Significantly, the Hide & Unhide button lie in Visibility category of Format button list menu. Also, the Hide Rows, Hide Columns, Hide Sheet etc. are subdivision of Hide & Unhide button. Additionally, the Unhide Rows, Unhide Columns and Unhide Sheet buttons also are a part of it.

Finally, the Organize Sheets category holds Rename Sheet, Move or Copy Sheet and Tab Color etc. Lastly, the Protect Sheet, Lock Cell and Format Cells buttons are present at the bottom within Format button.

Cells group buttons list MS Excel 2016

• Insert
  • Insert-Cells
  • Insert-Sheet Rows
  • Insert-Sheet Columns
• Delete
  • Delete-Cells
  • Delete-Sheet Rows
  • Delete-Sheet Columns
• Format
  • Cell Size
    • Row Height
    • AutoFit Row Height
    • Column Width
    • AutoFit Column Width
    • Default Column Width
  • Visibility
    • Hide & Unhide
  • Organize Sheets
    • Rename Sheet
    • Move or Copy Sheet
    • Tab Color
  • Protection
    • Protect Sheet
    • Lock Cell
    • Format Cells

See Next Post: Editing group buttons tools Home tab Microsoft Excel 2016

Terms related to this Post:

Cells Group in Excel
Cells-Group Excel
Cells Group in Excel 2010
Cells-Group-in-Excel 2013
Cells-Group in Excel 2016