How to Make a Number Line in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on June 30, 2023

This tutorial demonstrates how to make a number line in Excel and Google Sheets.


make a number line 18


Make a Number Line

Using Excel, you can create a number line that can be used to display a timeline. Say you want to create a timeline, displaying a couple of weeks, with days included.

  1. To insert a line, in the Ribbon, go to Insert > Shapes, and choose a line with arrows on both ends.


make a number line 1


  1. Click where you want to start the line, hold down the SHIFT key (to keep it straight), and draw the line.


make a number line 2


  1. To have equal spaces between days, resize the column widths. Select the columns you need, right-click anywhere in the selection, and choose Column Width…
    (Every cell is one day, so for this example, select 18 columns.)


make a number line 3


  1. Type in a smaller column width (2.29) and click OK.


make a number line 4


  1. Now you have cells formatted as small squares.
    Select the line, and in the Ribbon, go to the Shape Format tab, and choose black for the color.


make a number line 5


  1. In the Ribbon, go to the Shape Format > Shape Outline > Weight and choose a thicker line style (here, 2 ¼ pt).


make a number line 6


  1. Now, draw small vertical lines, to represent days, above the main horizontal line. This can be done using the cells’ borders. Select the first cell above the line (B2) and in the Ribbon, go to the Home tab. Click the arrow next to the Borders icon and choose Right Border.


make a number line 7


  1. Use the format painter to apply the border to the other cells. Select the first cell (B2) and in the Ribbon, go to Home > Format Painter.


make a number line 8


  1. Select the rest of the cells above the line to insert a right border for each cell.


make a number line 9


  1. Repeat Steps 8 and 9 to create a right border for each seventh cell under the line. These lines represent the first day of each week.


make a number line 10


  1. Insert text boxes for dates at the beginning of each week. In the Ribbon, go to Insert > Text Box.


make a number line 11


  1. Draw and resize the text box under the first line. Type in the first date (02-May).


make a number line 12


  1. To remove the text box outline, select the text box and in the Ribbon, go to Shape Format > Shape Outline > No Outline.


make a number line 13


  1. Now copy the text box. Right-click the text box’s border and choose Copy (or use the keyboard shortcut CTRL + C).


make a number line 14


  1. Position the cursor under the second week line, right-click, and choose Paste (or use the keyboard shortcut CTRL + V).


make a number line 15


  1. Type in the next week’s date (09-May) and repeat Steps 14 and 15 to insert the third text box (16-May).


make a number line 16


  1. Hide the gridlines to show only the number line. In the Ribbon, go to the View tab, and uncheck Gridlines.


make a number line 17


As a result, you have the number line with days and weeks marked.


make a number line 18


Number Line in Google Sheets

To create a number line in Google Sheets, first create a line in a drawing, and then insert that into your sheet.

  1. In the Menu, go to Insert > Drawing.


numberline gs menu


  1. In the Toolbar, click Line, and then drag to draw a straight line.


numberline gs selectline


  1. Add a left arrow head to the line, then a right arrow head.


numberline gs leftarrow


numberline gs right arrow


  1. Click Save and close to return to your Google sheet.


numberline gs save and close


  1. Resize the line by selecting it and dragging down with your mouse.


numberline gs resize line


  1. Now, resize the columns in your Google sheet.
    Select the columns to resize and right-click on the column header. Select Resize columns in the quick menu.


numberline gs resize columns


  1. Now insert right-hand borders for each cell in your number line.
    From the Toolbar, set the width of the border.


numberline gs border width


  1. Then, choose Right border for each cell on the number line.


numberline gs right border


    1. Once you have set all the right-hand cell borders (days), draw a text box. Once again, this involves inserting a drawing. In the Drawing window, click Text box.


numberline gs draw text box


  1. Then type in the date and click Save and close.


numberline gs text box


  1. Repeat Steps 10 and 11 to create the other text boxes.


numberline gs 2 textboxes


  1. Finally, in the View menu, switch gridlines off.


numberline gs nogridlines

AI Formula Generator

Try for Free

See all How-To Articles