Friday, January 22, 02:09
Home how To How to put a title on a line in a spreadsheet of ...

How to put a title on a line in an Excel spreadsheet

There are several ways to add a custom title to a spreadsheet in Microsoft Excel. Titles are not just about filenames - you can place one just above your spreadsheet data so viewers can understand it more easily.

Add a Header to Excel

To add a header title, click the "Insert" tab in the upper left corner of the workbook.

Click the "Text" menu to the right of the ribbon and click "Header & Footer".

You will shrink from the workbook so you will see all your data on one page.

Click anywhere in the "Header" section and enter your text.

To return to the default view of the workbook, click icon "Normal" in the page layout at the bottom of the document.

When you return to the "Normal" view of the workbook, you will notice that text does not appear. In Excel, these headers do not appear while you work on the workbook, but they will only appear printed. But if you want the title to always appear, see below what you can do.

Add a top line that is always visible

To add an always visible title, you can place it in the top row of the spreadsheet.

First, right-click anywhere in cell A1 (the first cell at the top left of the spreadsheet) and select "Insert".

Select "Entire Row" and click "OK" to add a blank row.

Enter the title anywhere in the new row. It does not matter the exact cell which you select as they merge in one second.


Highlight it unity of your new series in which you want to center your title. In this case, we will highlight from A1 to E1, in the center of our title in the top row.

Click on the header "Home" on the ribbon and do click in the "Merge & Center" option. Your text should now be in centre.

You can use these techniques to quickly add headers to Excel spreadsheets! We hope you find them useful!


Please enter your comment!
Please enter your name here

Teo Ehc
Teo Ehc
Be the limited edition.


Mac: How to see which model you have and when it was released

When you need support for your Mac - or want to install some kind of upgrade - you usually need to know the exact ...

Bill Gates: Will he work with Biden on COVID-19 / climate change?

Microsoft co-founder Bill Gates said on Twitter that he is looking forward to working with the new US President, Joe Biden, and ...

What are the rumors circulating about the iPhone 13?

Apple iPhone 13 will have a redesigned Face ID system that will have a smaller notch at the top of the screen, ...

Biden: How was the political transition in the US captured on social media?

As Joe Biden was sworn in as President of the United States, this important political transition was captured on popular social media. On January 20, ...

CentOS ceases to be supported but RHEL is offered for free

Last month, Red Hat caused a great deal of concern in the Linux world when it announced the discontinuation of CentOS Linux.

Microsoft Office 365 employee passwords leaked online!

A new large-scale phishing campaign targeting global organizations has been found to bypass Microsoft Office 365 Advanced Threat Protection (ATP) and ...

COSMOTE and Microsoft provide new cloud solutions for businesses

COSMOTE and Microsoft expand their cooperation, offering even more advanced and high quality cloud solutions, in large and small ...

Cyber ​​attacks in Eastern Europe are on the rise!

The cyber-attacks that have taken place in many US government agencies and companies in recent months have caused concern in the developing countries of ...

Tesla reduces the prices of the Model 3 in Europe

Tesla has reduced the prices of the Model 3 in many European markets, which reductions could be partly linked ...

iOS, Android, XBox users in the crosshairs of a new malvertising campaign

Recently a new malvertising campaign was discovered that targets users of mobile and other connected devices and uses effective ...