Rows

Quickly Delete Row Shortcut In Excel

Feb 06, 2020

To quickly delete a row in Excel, select a row and use the shortcut CTRL - (minus sign).

How To Excel Copy and Paste Visible Cells In Excel

Feb 04, 2020

If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells.

How To Quickly Highlightt Row Differences in Excel

Feb 04, 2020

This function is especially useful in large workbooks with many different sets of data.Some quick tricks for you to select and highlight the row differences in Excel.

How to delete blank rows or rows that contain blank cells

Feb 04, 2020

Blank rows aren't bad, but in most sheets, they're definitely undesirable.

How To Freeze Panes To Lock Rows Or Columns

Feb 03, 2020

Learn how to use the Freeze Panes feature in Excel to freeze rows or columns in Excel so that no matter where you go in a spreadsheet certain data remains visible.

How to Transpose Columns to Rows Use Paste Special in Excel

Jan 31, 2020

Use the ‘Paste Special Transpose’ option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function.

How to Autofit in Excel : Adjust Rows and Columns

Jan 31, 2020

Adjusting column widths and row heights in Excel can make for a much nicer looking spreadsheet.

How to Hide/Unhide Columns or Rows in Excel

Jan 31, 2020

Normally, we hide or unhide rows and columns by using the Hide or Unhide features from the right-clicking menu. Besides this method, we can hide or unhide rows or columns easily with plus or minus sign in Excel.

Some point in the past was the way to reference the last value on a row or on a column

Jan 12, 2020

I don't know how “cool” it is, but the most useful thing I have come across at some point in the past was the way to reference the last value on a row or on a column.

How many sheet,cells,rows and columns in one Excel

Jan 11, 2020

it depends on the Excel version you are using.