Click Print Titles under page layout. Under Sheets, check box "Gridlines".
*if you want see gridlines while working, check box "Gridlines' under Page Layout
Showing posts with label excelprojects. Show all posts
Showing posts with label excelprojects. Show all posts
Thursday, January 16, 2020
Creating border for each column
to create gridlines, create borders which, can be found at the top left hand corner of toolbar. Icon is a pencil overlapping a grid
Wednesday, October 23, 2019
Fill Series
SOURCE:
https://www.howtogeek.com/279148/how-to-automatically-fill-sequential-data-into-excel-with-the-fill-handle/
Click+drag plus (bottom right corner) for selected cells.
Then, type in fill series
#1-5
Subscribe to:
Posts (Atom)
-
to create gridlines, create borders which, can be found at the top left hand corner of toolbar. Icon is a pencil overlapping a grid
-
Sum of Rows/Columns =SUM( E8 : BC8 )
