Sometimes, it may be helpful to show lengthy formulas in multiple lines to make them easier to understand and debug. Ribbon: Click in a cell or select the (10)…ĥ days ago - When you create a new spreadsheet in Microsoft Excel you probably see a pattern of horizontal and vertical lines that create small (11)….Right-click and select Insert (figure 1). How to Insert a Row in an Excel Worksheet Drag your mouse pointer left or right to draw a horizontal (9)…
How to Add Horizontal & Vertical Lines in Excel | TechwallaĬlick anywhere on the spreadsheet and drag your mouse pointer up or down to draw a vertical line. If you want to add a line between row 1 and row 2 and you’ve highlighted all the cells in (8)… 4. (7)…Ĭlick the “Border” drop-down box, and select a location for the line. Insert options aren’t available if you select a column header. Select a cell in the table row or column next to where you want to add the row or column. How to Add a Row or Column to a Table in Excel | CustomGuide
