Insert rows between rows, remove blank rows and Row height in Excel in cm
Row height and column width in Excel are generally measured in pounds, but sometimes we need to use centimeters instead. Insert rows between rows, remove blank rows and copy row height and column width, these three cases can not be directly operated.
Chapters:
0:00 Row height in Excel in cm
0:42 Column width in Excel in cm (Excel column width pixels to cm)
1:08 Insert rows between rows in Excel
1:51 Excel remove blank rows
2:16 Excel copy row height and column width
Description:
Insert rows between rows, remove blank rows and Row height in Excel in cm
Row height and column width in Excel are generally measured in pounds, but sometimes we need to use centimeters instead, which was usually implemented in VBA before, and it needs to write code, which is difficult, especially when writing code that sets column width in centimeters. In addition to implementing it in VBA, there's a very easy way to set the row height and column width in centimeters without writing code, just switching a view. The above is one of the problems that are often encountered in row operations, in addition, insert rows between rows, remove blank rows and copy row height and column width, these three cases can not be directly operated, especially the first two cases; to insert rows between rows need to borrow an auxiliary column and sorting, to remove blank rows need to borrow the "Special", and to copy row height and column width as long as we pay attention to the selection.
One. Row height and Column width in Excel in cm
(1) Row height in Excel in cm
1. The cell row height is in pounds in normal view, if we want to use centimeters (cm) as the unit, we need to switch to the "Page Layout".
2. Steps: select the "View" tab, click "Page Layout"" in the upper left corner of the screen to switch to "Page Layout", right-click the row number 2 of the second row, select "Row Height" in the pop-up menu, open the "Row Height" setting window, enter 1.6cm, click "OK", the rows height become 1.6 cm, click "Normal" to switch back to the normal view, the rows height is still the height just set.
(2) Column width in Excel in cm (Excel column width pixels to cm)
1. Switch to "Page Layout" in the same way, select the C and D columns (click Column C, hold down the left button to move to Column D to select), right-click C, and select "Column Width" in the pop-up menu.
2. Enter the column width we want to set in the "Column Width" setting window that has been opened, , for example, 3cm.
3. Click "OK", the column widths of the selected columns C and D change to 3 cm, switch from "Page Layout" back to "Normal View", they are still 3 cm.
Two. Insert rows between rows in Excel
1. Enter 1 in the second cell (i.e. E2) in the last column of the table, move the pointor to the fill handle of cell in the lower right corner of E2, hold down the left button and drag down, then all the cells will be filled with 1, click the "Auto fill Options" icon, select "Fill Series" in the pop-up menu, then the cells of 1 will become a sequence of 1 to 5; select all cells from 1 to 5, press Ctrl + C on the keyboard to copy, select E9, press Ctrl + V on the keyboard to paste, select E2:E13, select "Data" tab, click "Sort A to Z" icon, open the "Sort Warning" window, select "Expand the Selection", and click "OK" to insert rows between rows in Excel.
2. A total of five empty rows are inserted in the above operation, and 5 serial numbers are generated by dragging down in column E of the auxiliary column, so a few empty rows should be inserted interlaced, and several serial numbers should be generated in the auxiliary column.
Three. Excel remove blank rows
Select one of the columns (for example, column B), press Ctrl + G on the keyboard to open the "Go To" window, click the "Special", select "Blanks" in the window that has been opened, click "OK" to select all empty cells in the table, right-click one of the cells (B3), select "Delete" in the pop-up menu, open the "Delete" window, select "Shift cells up", click "OK", then all empty rows in the table are deleted.
Note: Select the "Home" tab, click "Find & Select" in the upper right corner of the screen, and select "Go To" from the pop-up menu to open the "Go To" window.
Four. Excel copy row height and column width
Select the second and third rows (be sure to click the row number to select them, otherwise the row height and column width will change after pasting), press Ctrl + C on the keyboard to copy, select the A11 cell, press Ctrl + V on the keyboard to paste, then the second and third rows will be copied successfully, and the row height and column width will remain the same.
Watch video Insert rows between rows, remove blank rows and Row height in Excel in cm online without registration, duration hours minute second in high quality. This video was added by user Loinsure 18 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 237 once and liked it 1 people.