0
How do get the get the column and row lines to print in a spreadsheet?
Wiki User
∙ 13y ago
I like to use the MOD() function and conditional formatting to apply formatting like that. If you've never used conditional formatting you will probably want to read up on it. This formula: "=MOD(ROW(),2)>0" will test for the row and see if it is an odd-number row. That is the condition. If the condition is true, you state what the formatting ought to be if it is...You would apply this to the entire spreadsheet by selecting all of the cells by clicking on the upper left row-column header cell (that lights up all of the cells).
That conditional formula is not, though, going to give you an underline under each row--it will underline every other row...To underline every row, light up all of the cells and do a right click in the middle of the sheet. Select "format cells" and from the menu, click "border" on the tab. Select the mid border and bottom border and click "OK".
Wiki User
∙ 13y ago
Wiki User
∙ 13y agoPrint Preview > Page Setup > Sheet Tab > Click Gridlines in the Print section
Add your answer:
Earn +20 pts
What is more smallest a column or a row?
There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.
Is a spreadsheet label the intersection of a column and a row?
No. A label is a heading for data in a spreadsheet. It would be in a cell, which is what the intersection of a column and a row is.
Is a column and row go in a spreadsheet cell?
A cell is the intersection of a column and a row.
How do you print a spreadsheet without the letters and number row and column?
You can turn them off in the options when printing. Check out the options section.
What is a row or column in ICT?
A row is a horizontal line of cells in a spreadsheet or table. A column is a vertical line of cells in a spreadsheet or table.
Where a column and row insersect on a spreadsheet?
cell
What is the intersection of a row and column in a spreadsheet?
Cell
What is the insection of a column and row in an Excel spreadsheet?
cell
What is a row and column data chart called?
spreadsheet
Is excal is formed due to intersectin tof two rows and columns?
Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.
In a spreadsheet and a table the intersection of a row and a column is?
A row (numbers) and a column (letters) intersect at a cell. Example: A1, is the first cell in the top left-hand corner of a spreadsheet.
In a spreadsheet and a table the the intersection of a row and a column is a?
A row (numbers) and a column (letters) intersect at a cell. Example: A1, is the first cell in the top left-hand corner of a spreadsheet.
