How To Make A Grid On Microsoft Excel
To make a grid in Microsoft Excel, select the cells you want to use, open the Borders menu on the Home tab and choose All Borders. Adjust the column widths and row heights to suit your layout. Excel already has worksheet gridlines, but borders let.
Which licences fit your PC setup?
Prices are an AUD snapshot, not a live quote. Confirm variant and total on the listing.
-

Office 2024 Pro Plus key
$20.00 AUD
$39.00 -

Windows 11 Pro key
$14.99 AUD
$29.00 -

Windows 11 Home key
$18.88 AUD
$37.00
Create a grid with cell borders
Use borders for a planner, checklist, stock sheet or any layout that needs clearly defined boxes. The following steps use the desktop ribbon; the position of controls can differ between Excel apps.
- Open a workbook and select the worksheet where you want the grid.
- Drag across the cells you want to include. Include space for headings and any blank rows people will fill in later.
- On the Home tab, find the Borders drop-down menu in the Font group.
- Choose All Borders to add lines around every cell in the selected range.
- Enter your headings in the first row, then add your data underneath.
Outside Borders draws only the perimeter of a selection. Choose All Borders when you need both the outer edge and the lines separating individual cells.
Change the line style and colour
For more control, select the range, right-click and choose Format Cells. Open the Border tab, choose a line style and colour, then apply them using the Outline and Inside presets or the border preview. Click OK when the preview shows the grid you want.
Choosing a style alone does not apply it to every edge. Use the preview to check which lines will change. Thin internal lines usually keep a data sheet readable; a stronger outside border can help separate the grid from surrounding notes.
To remove applied borders, select the relevant cells and choose Home, Borders, No Border. This removes border formatting without deleting the cell contents.
Adjust row heights and column widths
Column width affects the whole column, and row height affects the whole row. Resizing cells in your grid can therefore change the layout of other content in those same rows or columns.
- Select the column headings above your grid.
- Drag a boundary between selected column headings to set a consistent width. Alternatively, right-click a selected heading and choose Column Width.
- Select the row numbers beside the grid.
- Drag a boundary between selected row numbers, or right-click and choose Row Height.
- Check that headings and sample entries fit. Use Wrap Text on the Home tab for labels that need more than one line.
For a grid that follows the length of existing entries, use Home, Format, AutoFit Column Width or AutoFit Row Height. For a blank form, set the dimensions manually so there is enough space to write or type.
If you want square cells, adjust their appearance on screen rather than entering the same number for height and width. Excel measures these dimensions differently, so equal values do not produce squares. Check Print Preview too if the squares are intended for paper.
Show worksheet gridlines without adding borders
Worksheet gridlines are the faint lines that help you navigate cells. They are useful while entering data, but they are separate from the borders applied to a selected range.
On the View tab, find Gridlines in the Show group and tick it to display them. Untick it to hide them on the active worksheet. This setting affects the sheet's gridline display, rather than just the cells you selected.
Hiding gridlines does not remove borders. Likewise, choosing No Border does not hide worksheet gridlines. If lines remain after changing one setting, check the other.
A cell fill can obscure worksheet gridlines. If lines disappear under a coloured heading or shaded area, apply borders to those cells to keep the divisions visible.
Print the grid clearly
Borders are useful for printed forms because you can define exactly which cells have lines, including empty boxes. Worksheet gridlines need a separate print setting.
- If you are using worksheet gridlines, open Page Layout and tick Print under Gridlines in Sheet Options.
- Select the range you want on paper. Use Page Layout, Print Area, Set Print Area if you need to limit the output to that range.
- Open File, Print and inspect the preview.
- Check that the grid fits within the page, the text is readable and all required rows and columns appear.
- Adjust orientation, margins or scaling if needed, then check the preview again.
For blank writing boxes, apply borders across the entire intended range. Do not assume that switching on printed gridlines will include every empty cell you want. Avoid shrinking a large sheet so far that its labels become difficult to read.
Organise a grid for ongoing data entry
For a list you will update regularly, use one row per record and a clear heading for each column. Keep dates, quantities and descriptions in separate columns so the entries can be sorted and filtered consistently.
To turn that range into an Excel table, select it, choose Insert, Table, check the range and tick My table has headers if appropriate. Click OK. A table adds header filters and consistent formatting; it can also expand as you add data directly below it.
Once the structure is ready, a Microsoft Excel IF statement can help label entries according to a condition, such as whether a quantity is below a threshold. Add formulas after the headings and data types are settled.
If you prefer a prepared layout, use File, New and search for a relevant template, such as an inventory list or planner. Review its headings and formulas before replacing the sample entries.
Keep labels brief and consistent. If you are drafting accompanying instructions in Word, the guide to accessing the thesaurus in Microsoft Word can help you choose clearer wording. More application guides are available in the Microsoft Office blog.
Select a small range, apply All Borders and enter a heading plus one sample row. Check the cell sizes and print preview before extending the grid.
Other editions for separate workloads
Other editions for separate workloads; prices in AUD, confirm the total on the listing.
-

Windows 10 Pro key
$12.00 AUD
$15.00 -

Microsoft 365 Pro Plus, 5 devices
$15.00 AUD
$29.00 -

Windows Server 2022 Standard
$120.00 AUD
$239.00
How to check this worked
- Open Settings, System, Activation and confirm the edition shown.
- Enter the key and run activation; expect a green tick within a minute.
- Reboot and re-check activation survives the restart.
FAQ
What else should you know before buying?
- What do I need before starting?
- Read the requirements and confirm the edition first; the steps assume the machine is compatible.
- How do I know the licence is genuine?
- Activate on Microsoft's servers and check Settings, System, Activation. A working activation is the test.
- Is this a subscription?
- Keys sold here are one-time lifetime licences. Microsoft 365 plans are billed by Microsoft instead.
- What if the key fails?
- Email hi@ms.codes with the order number and a screenshot. Replacement or refund applies within 30 days.
Check who prepared and reviewed this guide
- Written by
- MS.Codes editorial
- Reviewed by
- Support team
Last verified: (source review; see test status above).