How to make a header on google sheets on pc or mac

Download PDF contributed by Nicole Levine, MFA Download PDF X Thi article wa contributed by Nicole Levine, MFA. Nicole Levine i a technology writer and editor for . he ha over 20 year of experience w

Content

Download PDF contributed by Nicole Levine, MFA

This article was contributed by Nicole Levine, MFA. Nicole Levine is a technology writer and editor for . She has over 20 years of experience writing technical documentation and leading support teams at hosting and software companies. Nicole also holds a master’s degree in creative writing from Portland State University and teaches essay writing, fiction, and magazine creation at various institutions.

This article has been viewed 1,052 times.

In this Article: Steps Related Articles

This will teach you how to add a column header row to a spreadsheet in Google Sheets on a computer.

To step

Open https://sheets.google.com in a web browser. If you’re not already signed in with your Google account, sign in now.

Add an empty row in the spreadsheet. If you’ve created a new spreadsheet or already have a header row, you can skip this step. Otherwise, follow these steps to add a new row at the top of the sheet:

  • Click on the number next to the top row in the sheet. This marks the row.
  • Click on the menu Insert.
  • click on Row above. An empty row should now appear at the top of the sheet.

Click the number next to the header row. This marks the row.

Click on the menu View.

click on Lock.

click on 1 row. The header row is now frozen, meaning it will stay in place when you scroll down the spreadsheet.

  • To enable the feature that allows you to sort and filter data by clicking the column header, click the header row number, then click the menu data and then select Create a filter. You can now click the green icon in each heading to sort data.

Advertisement

Ben Stockton is a freelance tech writer from the United Kingdom. In a past life, he was a UK college lecturer, training teens and adults. Since leaving the classroom, he’s been a tech writer, writing how-to articles and tutorials for MakeUseOf, MakeTechEasier, and Cloudwards.net. He has a degree in History and a postgraduate qualification in Computing. Read more.

How to make a header on google sheets on pc or mac

A Google Sheets spreadsheet doesn’t have a visible header or footer until you decide to print. If you want to add headers and footers to a Google Sheets spreadsheet, you’ll have to use the printer settings menu—here’s how.

To begin, open the Google Sheets spreadsheet that contains your data. At the top, click File > Print to view the printer settings menu for your document.

How to make a header on google sheets on pc or macPrint to access the printer options for your spreadsheet.” width=”409″ height=”600″ src=”https://www.howtogeek.com/pagespeed_static/1.JiBnMqyl6S.gif” onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);” onerror=”this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);”/>

In the “Print Settings” menu, you can customize the layout and design of your spreadsheet to make it suitable for printing. To add a new header or footer, click the “Headers and Footers” category in the menu on the right.

How to make a header on google sheets on pc or mac

A list of available options for both headers and footers will appear. Click the checkbox next to a preset option (for example, “Page Numbers”) to enable it.

How to make a header on google sheets on pc or mac

You can add page numbers, a workbook title, sheet name, or the current date or time to your printed spreadsheet. Google automatically determines whether to place these in the header or footer.

For example, page numbers are automatically placed in the footer, while a workbook title will be placed in the header. If you want to change the position of a preset option or add any custom text to a header or footer, click “Edit Custom Fields.”

How to make a header on google sheets on pc or mac

The print view on the right will change and allow you to edit the text boxes in the header or footer. Click a box to make any changes to your header or footer.

How to make a header on google sheets on pc or mac

When you’re ready to save your changes, click “Confirm” at the top right to return to the “Print Settings” menu.

How to make a header on google sheets on pc or mac

If you’re happy with the changes you made to your header or footer, click “Next” at the top right.

How to make a header on google sheets on pc or mac

You’ll now be taken to your browser or operating system’s printer options menu. Here, you can specify more print settings for your spreadsheet, like the number of copies you want to print.

The changes you made to your header or footer will save automatically, and they’ll also be applied to any future copies of your Google Sheets spreadsheet that you print.

Creating a header row in Google Sheets makes it much simpler to identify the information contained within a column. You can also choose to keep that header row visible at the top of the spreadsheet as you scroll. Use these steps to make a header row in Google Sheets.

Spreadsheets can quickly become difficult to read as you add a lot of information. It becomes even more complicated when the information in your columns is very similar to other columns.

One way to simplify this is by creating a header row. By entering a description of the type of information that is contained within a column it becomes easier to edit, and the information is easier to read.

Once you’ve added those descriptions, you can then choose to freeze that header row at the top of the sheet. This allows you to scroll further down in the spreadsheet while still keeping the header row visible.

Our guide below will show you how to create a header row in a Google Sheets spreadsheet.

How to Make a Header Row in Google Sheets

  1. Open your Google Sheets file.
  2. Add a description into each cell in row 1.
  3. Select the View tab at the top of the page.
  4. Choose the Freeze option, then click 1 row.

Our article continues below with additional information on adding a header row to a Google Sheets spreadsheet, including pictures of these steps.

How to Create a Header Row in Google Sheets (Guide with Pictures)

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Firefox or Safari.

Step 1: Sign into Google Drive and open your spreadsheet or create a new one.

Step 2: Type a description for the first column into the A1 cell, then repeat for each additional column in the spreadsheet.

For example, in the image below I have three columns. The “First Name”, “Last Name”, and “Employee ID” text are all going to be the headers for the data that is contained in the rest of the cells in those columns.

How to make a header on google sheets on pc or mac

Step 3: Select the View tab at the top of the window.

How to make a header on google sheets on pc or mac

Step 4: Click Freeze, then choose the 1 row option.

How to make a header on google sheets on pc or mac

Now when you scroll down in your spreadsheet the header row will stay frozen at the top of the spreadsheet so that you can easily add the correct information in each of your columns.

If your spreadsheet already has data in its cells then you can insert a new row at the top by right-clicking on the row 1 label at the left side of the window and choosing the Insert 1 above option. This will slide all of your data down one row.

Frequently Asked Questions About Google Sheets Header Rows

Our article above discusses the steps that you need to follow if you want to make the first row of your spreadsheet into a header.

You must first place the headers for each of your columns into the cell in the first row, then you can select the View tab at the top of the window and elect to freeze the top row. This will ensure that the data in that first row remains visible as you scroll down through the rest of the spreadsheet.

Creating a Google Sheets header is slightly different, as it is a separate entity from the header row.

While a header row in a spreadsheet identifies the type of data that is in a column, a “header” in a spreadsheet is going to contain information like page numbers, or perhaps an author name, a company logo, or a name for the spreadsheet.

You can create a header in Google Sheets by going to File > Print then clicking the Headers & footers tab at the right side of the window. There you will be able to select the type of data that you want to include in the header. You can also select the Edit Custom Fields option if you would like to include data in the header for which there isn’t a listed option.

Creating a header row in your Google Sheets spreadsheet can be as simple as typing descriptive information into the top row of the spreadsheet.

While our article focuses specifically on freezing the top row so that it stays visible, as well as making it possible to print that row at the top of every page, simply placing a description in the first row is often sufficient for turning that row into a header row.

More Information on How to Make a Header Row in Google Sheets

For many spreadsheets it’s is very likely that you only want to freeze the first row. The important part when you freeze rows in a spreadsheet is ensuring that they stay visible when you scroll so that you don’t place data into the wrong column. But you may want to freeze more than one row if your spreadsheet structure requires multiple columns, or if you are using more than one row to display important information. If so, you can choose to freeze rows up until the one that is currently selected in your spreadsheet.

To select a row, click the row number that appears at the left side of the window. You can use the same action to select an entire column by clicking that column letter at the top of the sheet.

The View menu at the top of the window contains not only the option to freeze rows, but also hide or show gridlines, view formulas, or zoom in on your data. While it doesn’t have the various viewing options that you would find in Microsoft Excel, many Excel users have found Google Sheets to be a fairly capable alternative to Microsoft’s paid spreadsheet application.

Using Google Sheets as a former Excel user can require a bit of a transition period. While many of the features in the application are easy to find, certain things, especially printing and viewing options, may require a bit of experience before you become familiar with them. If there’s something that you want to do which affects the way that your Google Sheet appears on the screen or when you print, then there is likely a way to apply that change. Definitely familiarize yourself with the the View menu and the menu found at File > Print, as that is where most of those options are found.

Additional Sources

  • How to merge cells in Google Sheets
  • How to wrap text in Google Sheets
  • How to alphabetize in Google Sheets
  • How to subtract in Google Sheets
  • How to change row height in Google Sheets

How to make a header on google sheets on pc or mac

Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.

After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.

His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.

With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage. Read more.

How to make a header on google sheets on pc or mac

When reviewing or analyzing a spreadsheet, one thing that you might need to do is sort your data. Fortunately, you can easily sort an entire sheet or a range of cells alphabetically, numerically, or by color in Google Sheets.

Table of Contents

  • Sort an Entire Sheet by a Column
  • Sort Only a Range of Cells
  • Sort by Color in Google Sheets

Sort an Entire Sheet by a Column

One of the most common ways to sort a spreadsheet is by using a specific column. For example, you might want to sort a column by the lowest value, but also make sure that all data in the sheet remains intact.

Freeze the Column Headers

If you have column headers in your Google Sheet, you’ll want to freeze that row before applying the sort. Otherwise, the data in the headers will be included.

Start by selecting the row containing the column headers. Then, click View > Freeze > 1 Row in the expanding menu.

How to make a header on google sheets on pc or mac

This will keep the column headers in place and out of the sorted data.

Sort the Data

Next, select the column and then use one of these three actions to sort the sheet by the selected column.

  • Click “Data” in the menu and choose “Sort Sheet By Column X, A to Z” or “Sort Sheet By Column X, Z to A.”
  • Right-click the column and choose “Sort Sheet A to Z” or “Sort Sheet Z to A.”
  • Click the arrow next to the column header and choose “Sort Sheet A to Z” or “Sort Sheet Z to A.”

How to make a header on google sheets on pc or mac

If you’re sorting numerical data, using A to Z will place the lowest value at the top. And of course, using Z to A will place the highest value at the top.

You’ll see your sheet update immediately to sort the entire sheet by the column that you selected.

How to make a header on google sheets on pc or mac

Sort Only a Range of Cells

Maybe you have a spreadsheet with a range of cells that’s unrelated to the rest of the data. In this case, you can sort only that range without affecting the remaining data.

Use a Quick Sort

You can quickly sort the range of cells from A to Z or Z to A. Select the cell range, click “Data” in the menu, and pick “Sort Range By Column X, A to Z” or “Sort Range By Column X, Z to A.”

How to make a header on google sheets on pc or mac

Use a Custom Sort

If the range of cells that you’re sorting contains a header, or you want to sort by multiple columns, this option is the way to go.

Select the range of cells and then either click Data > Sort Range or right-click and pick “Sort Range” in the shortcut menu.

How to make a header on google sheets on pc or mac

A window will pop open for you to choose the sorting options. Check the box at the top if the “Data Has a Header Row.” This will keep the header from being sorted with the other data.

How to make a header on google sheets on pc or mac

Choose to sort by A to Z or Z to A and click “Sort.” You’ll see only the range of cells that you selected in your sheet adjust per the sort order.

How to make a header on google sheets on pc or mac

If you want to add another range of cells or a column, click “Add Another Sort Column” and choose the order for that as well. Then, click “Sort.”

How to make a header on google sheets on pc or mac

Sort by Color in Google Sheets

Using color in your spreadsheet is handy for spotting certain data quickly. Whether you use color for the text or to fill the cell, you can use this sort order as well. The main difference is that you must create a filter to sort by color.

Select the entire sheet or just the range of cells that you want to sort by color. Click Data > Create a Filter from the menu.

How to make a header on google sheets on pc or mac

Click the filter icon at the top of the column that you want to use for the sort. Do this for sorting the entire sheet or for just the range of cells.

Move your cursor to “Sort by Color” in the small window. Then, move to “Fill Color” or “Text Color” depending on which you prefer. You’ll see another pop-out displaying the colors that you’re using. Choose the color that you want highest in the sort order.

How to make a header on google sheets on pc or mac

Note: If Fill Color or Text Color is grayed out, you are not using that color in the selected cells.

Like with the other sort options, your sheet or cell range will immediately update to sort by the color that you picked.

You can then disable the filter by clicking Data > Turn Off Filter.

How to make a header on google sheets on pc or mac

Be sure to check out the handy sorting option in Google Sheets the next time you’re reviewing your data. And if you use Microsoft Excel in addition to Google Sheets, you can sort by values or sort by date in Microsoft Excel just as easily.

Hi! Welcome to The Data Are Alright, a blog about tips and tricks for changemakers. Most of you found your way here through Google (this is my most popular article, so it seems like LOTS of people need help with this feature) – and you’re in the right place! While you’re here, why not check out some of my other popular posts and consider subscribing?

Okay, okay, I admit it, I used to be a staunch Excel snob who would turn up her nose at Google Sheets… so much so that I didn’t even realize that core Excel functions are now available in Google Sheets (like pivot tables! and vlookups!). My, my, my how the … tables have turned! So let’s dig into the Tables functionality and why they’re important for changemakers managing a spreadsheet…

  1. In Tables (as opposed to regular old spreadsheets), rows alternate colors, which makes them prettier AND easier for your eyes to track
  2. Tables offset your Column Titles in a darker color
  3. Tables make it super easy to sort and filter your data
  4. When you sort and filter your data, you can find blank cells and inconsistencies (and more!) I’ll save sorting and filtering for another blog post, but trust me, you can do all kinds of awesome things with this feature combo.

Tables in Excel (refresher)

Excel makes “Format as table” really simple. All you have to do is select the data that belong in your table, and then click “CTRL + T” (Windows) or “Apple + T” (Mac). Alternatively, there’s a Format as Table button in the standard toolbar.

Tables in Google Sheets

Unfortunately, Sheets doesn’t have a “one stop shop” for Tables. Here are two very simple steps that give you a lot of the same functionality, but with added Google benefits, like being free, cloud based, and shareable with multiple collaborators.

How to make a header on google sheets on pc or macSelect the data that belong in your Table (in this case, my sample Phonebanking data). After you select your cells, Google Sheets will display a green border around the data. After selecting the data, click the the Filter button (funnel icon) in your toolbar. If your screen is not maximized, you may need to click a small triangle button to see more options. Then, you can click, “Filter”. The Column Labels and Row Labels (A, B, C, 1, 2, 3, etc) will highlight green and little triangles will appear in your Column Names. You should always select the Filter button after you have given your columns names (like Name, Called, and RSVP? How to make a header on google sheets on pc or macFinally, select your data one more time and click the Format menu in your tool bar. Then, select Alternating Colors. Google Sheets will open an Alternating Colors dialogue box in the side bar. You can select from pre-defined alternating color pallets or design your own.

From this point forward, as you add additional data to your rows or columns, Google Sheets will automatically incorporate your data into the alternating color theme.

Also, you can use those handy striped triangles in your column header to select, sort and filter down your data so that you can see just the important segments at any given time. This becomes really useful if you want to see JUST the “RSVP Maybes” or just the people who haven’t been called.

I hope you all have a wonderful week! I have some exciting TDAA projects up my sleeves, so stay tuned for more!

Google Docs, as we all know, is a part of G-suite and gives us a cloud platform to create, share and edit our documents. While using Google Docs we need to know a lot of its features such as choosing a template, creating or removing Header, voice typing and many others. This app looks normal but it can do a lot and helps you to collaborate better, write faster, and produce the best results with its awesome features.

Today, we are considering Google Docs’ feature that is most-talked about but used by a very few. Yes, in this article we will tell you how to add or remove a Header in Google Docs.

A Header in Google Docs or any other document contains a lot of information. It might vary from one document to another but it contains the most useful information such as a title, date, name and page number on all the pages.

Creating a Header on Google Docs is as easy as double-clicking on the topmost part of the document or going to Insert tab > Header & Footer > Header. Similarly, removing a Header on Google Docs is like clicking on the Header part and deleting the text and clicking out of the Header space. Let us learn step wise the process to create and remove Header in Google Docs.

How to Add or Remove Header In Google Docs:

  • Add A Header In Google Docs
  • Remove A Header In Google Docs

How to Add A Header In Google Docs?

Headers in any document contain vital information and these can be the same or different on every page. Adding a text to the Header is like adding text to the main document. Do you know the importance of Header in a doc? A Header can be different for one page and same for the rest i.e. it can be customized based on your document requirements. For instance, if you are writing a book, you can use a Header to add page numbers in Google Docs.

How to make a header on google sheets on pc or mac

Similarly, you can add Footer to your document. It might include your book name for instance or if you want you can insert page numbers in the Footer section as well. Here’s how to add Header in Google Docs:

You can quickly add Header to Google Docs using the browser-based app. Follow the steps below for more clear instructions to add a Header from a web browser.

  • Open a document in Google Docs and scroll to the top of the document.
  • Now go to Insert tab, select Header & Footer, and then click Header.

How to make a header on google sheets on pc or mac

  • Also you can use the keyboard shortcut i..e Ctrl+Alt+O Ctrl+Alt+H to locate the Header part of the document.

Next, you’ll see an option with a checkbox saying ‘Different First Page’. Check mark this option to mention different Headers in different pages. Also you can use different Headers on odd and even pages. Then, select from the Options drop-down menu.

How to make a header on google sheets on pc or mac

  • Enter the text in Header and use the Formatting Tools to change alignment, size, font, and text color.
  • Now, click anywhere in the document to exit the Header.
  • If you have checked the option ‘Different First Page’, then you have to again select the Header area on the next page to enter the Header text for the remaining pages of the document.

How To Add Header In Google Docs On Android And iOS?

Adding a Header to your document on Android or iOS apps is not available with many options. In a mobile app, set a Header for the first page and then set a Header for the other pages as well. Here are the steps you need to follow to add a Header in Google Docs.

  • On your Android or iOS device, open Google Docs app.

How to make a header on google sheets on pc or mac

  • Once it displays the first page of the document, tap the Edit icon at the bottom right (the pencil icon).

  • Then, tap the three-dots icon at the top-right to open the More menu.
  • Toggle on the Print-Layout

How to make a header on google sheets on pc or mac

  • Tap the Header area of the page and enter the Header text. This Header text will appear on the first page only.
  • To add Header text on the other pages, you need to add separately after scrolling down to the second page of the Google Docs.
  • You can now use the tools in the Formatting Toolbar to edit the font, text size, text color and alignment.

How to make a header on google sheets on pc or mac

  • Toggle off the Print Layout, after you’re satisfied with the Header text.

How to make a header on google sheets on pc or mac

That’s it! This is how you can add a Header in your document on Google Docs. Let us proceed ahead to learn how to remove the Header in Google Docs.

How To Remove Header In Google Docs?

Removing a Header from your document is as simple as clicking the mouse. Yes, it just needs a command and you can simply remove a Header i.e. delete the text into it. When you want to remove a Header from Google Docs mobile app, you’ll manually need to delete the text.

While using Google Docs on the web, you need to go to the Header section, locate Options tab, from the drop down menu choose Remove Header. Alternatively, you can go to the Format tab, Headers & Footers, and choose Remove Header.

How to make a header on google sheets on pc or mac

If on any document, there is a different first page Header or odd or even Headers, each of them has to be deleted individually.

Note: Grammarly is one of the best apps to take care of your grammar in all your important documents. Check its review here.

How To Remove Header In Google Docs On Android And iOS?

Just like adding a Header in Google Docs, there is no automatic way to remove a Header in Google Docs while using Android and iOS mobile apps. You can also use Delete or Backspace key, or select the text and use the Cut option on mobile devices. Follow the steps listed here to delete a Header in Google Docs:

  • Open Docs app and a document.
  • On the top-right, click on the three-dots icon for More menu options.
  • Toggle on the Print-Layout
  • Tap the Header area of the page you want to delete.
  • Select the Header text and tap Cut.
  • Exit the Header by clicking anywhere on the document.

Wrapping Up

That’s all folks! Using Google Docs or similar apps have now been a part of our daily routine especially during this time of quarantine and social distancing. These apps are quite useful during work from home as you can keep your document ready-to-go and accessible on your smartphones. You can create, edit and share them anywhere and anytime.

Do you use Google Docs to create and manage your documents on the go? Let us know in the comments section below.

Learning how to delete headers in google docs is necessary if you want to make these changes in a certain document.

May it be that you received a document from someone else or if you are using an existing document to make something new, there might be information written and placed in the header which is no longer relevant to you or to the document you are writing or editing. Such information might need updating.

Fortunately, it is fairly easy and simple to delete a header in Google Docs. The steps are similar to how you delete any kind of information or part in the body of your document.

Note that once you delete or change the header of a page, the headers of other pages in the document will also be updated with the changes you have made, displaying the new layout of the header or no header layout at all.

How to Delete a Header in Google Docs in a Computer

How to make a header on google sheets on pc or mac

Follow this step-by-step guide on how to delete the header of a document in Google Docs entirely.

  1. Open the document file in your Google Drive you wish to delete the header of.
  2. At the opened document in Google Docs, click on the header section.
  3. Type in “Ctrl + A” on your PC or “Command + A” on your Mac. This will highlight everything placed on the header of the document.
  4. Click delete or “backspace” to delete all the information on the header.
  5. Click anywhere on the document body section once finished.

How to Delete or Update Information in the Header

How to make a header on google sheets on pc or mac

Using your browser version of Google Docs on your PC, this step-by-step guide will help on how you can delete or update the information in the header of a document.

  1. Open your Google Drive and select the document file you would wish to open in Google Docs to update or delete any information in the header from.
  2. Once the document is open, click on the header section located at the top part of the document.
  3. Then, delete the information you want to delete in the header or update it as you wish.
  4. You can then return to the body of the document by simply clicking in anywhere in the document body section of the document.

How to Delete a Header in Google Docs Using an Android Phone

How to make a header on google sheets on pc or mac

Delete headers of a document in Google Docs using your Android phone by following these simple steps.

  1. Open the Google Docs app on your Android Phone.
  2. Select and open the document you wish to delete the header of.
  3. Then, tap on the “Pencil” icon at the bottom of the screen or the document to enable and start editing.
  4. Click on the Overflow Menu, the three dots lined vertically, at the top part of the screen.
  5. Then, hit the “Print layout” to enable.
  6. Now, click on the top part of the page or the header.
  7. If you want to delete the header entirely, highlight everything in the header. If you only wish to delete a portion of information in the header, only highlight the information you want to delete.
  8. The, click on the “backspace” key to delete the header or the information on the header you want to get rid of.

The header should be removed successfully, and you can hit back the body section to go back to the document of the body.

How to Delete a Header in Google Docs Using an iPhone or iPad

How to make a header on google sheets on pc or mac

Deleting document headers in Google Docs using your iPhone or iPad is also as easy when using an Android phone. Follow these simple steps to do so.

  1. Open the Google Docs app on your iPhone or iPad.
  2. Open the document you want to edit or delete the header of.
  3. Tap “Edit” by clicking on the pen icon usually located at the bottom part of the screen.
  4. In the top right of the screen, click on the Overflow Menu, the three dots lined horizontally.
  5. Then, hit the “Print Layout” to enable if still not turned on.
  6. Now, click on the top part of the page or the header section.
  7. Highlight everything in the header if you wish to delete the entire header. If you only want to delete a portion of information in the header, only highlight the information you want to get rid of or to change.
  8. Then, click on the “backspace” key to delete the header or the information on the header you want to get rid of.

Make sure that the “Print layout” mode was turned on. Otherwise, you wouldn’t be able to see and view as well as edit the header of the document.

How to Add Header in Google Docs

How to make a header on google sheets on pc or mac

Once you have deleted the existing header of the document you are working on, you might want to add a brand new header. To do this simply, follow the steps outlined below.

  1. If your document is already open, go towards the top left portion of the screen and click on “Insert” then “Header and page number”.
  2. Choose “Header”.
  3. Enter the information you want to be placed in the header of the document you are working on.

If you wish to make the header on the first page of the document to the rest of the pages, check the “Different first-page header/footer” option. You can add various formatting in Google Docs, such as superscript in your header.

However, note that you can only make the header of the first page different from the headers of the rest of the pages and you cannot add a different header for every page of the document.

Conclusion

Deleting a header makes sure you get rid of the unnecessary and irrelevant information in your document, especially if you are only making use and editing old and used documents. You should be able to know how to delete headers in Google Docs whether you are using a computer, and Android phone, or an iPhone or iPad.

How to make a header on google sheets on pc or mac

On a Google Form, users can upload a custom image for the header banner. These images must be the odd size of 1600 pixels wide and 400 pixels tall. If your image is too wide or too tall, Google will force you to crop it to the correct aspect ratio before uploading it for your Form.

tl;dr: Use this Google Forms Header template to resize or make a custom header.

In this article, I’ll show you how to resize an image for the header of a Google Form. I will also show you how to design a custom header JPG from scratch that will fit in the Google Forms header area.

How to make a header on google sheets on pc or mac

Size and Appearance for a Google Forms Header

All Google Forms have a space at the top of the webpage for a custom header image. By default, this area will be filled with a color from the Form’s “theme.” Form creators can choose a stock image from an gallery or upload a JPG or GIF for the header area.

Google Forms will force you to crop your header image to 1600 x 400 pixels. To resize your image to this exact size, use this free Google Forms header template or use a free web tool like Kapwing’s Studio to resize (see next section for instructions).

How to make a header on google sheets on pc or mac

Google Form headers do not have a standard size. Google will force you to crop your image to 1600 x 400 pixels, but the actual appearance of the image depends on how big the viewers screen is. If the user’s screen is wider than 1600 pixels, the image will stretch and zoom in, obscuring the content in the lower part of the screen.

For example, I uploaded this logo image with the word “Kapwing” centered.

When I preview this Google form, here are the different appearances on three different screen sizes:

How to make a header on google sheets on pc or mac Header on a very wide screen

As you can see, the bottom 150 pixels are always cut off. Keep this in mind when designing a graphic for your Form takers. All important content should be in the top half of your header image.

Resize or Design a Custom Google Forms Header

To make a Google Forms header image, open the Kapwing Studio and start with a blank canvas. Start out by setting the right size for the JPG area. Click the “Custom Size” in the right-hand panel and enter 1600 and 400 to set the exact pixel size.

How to make a header on google sheets on pc or macCustom Size

After you have the right canvas size, use Kapwing’s tools to make your Google Forms header. If you already have an image or video that you want to resize, upload it to the canvas and use the handlers to resize it to the correct aspect ratio.

How to make a header on google sheets on pc or macResizing an image layer in Kapwing Studio

Alternatively, creators can use Kapwing’s image editing tools to design a custom graphic. Businesses, schools, or nonprofits can upload their logo or search for it using the Images tool. Brands or organizations can set the background color to a custom hex code. You can also add a text box and shapes to create an attractive layout or collage images together for your Forms cover.

In my example, I set the background to a light purple that corresponds to our company’s colors. Then, I uploaded a PNG logo, inserted a white speech bubble sticker, and added a text overlay. I changed the font, style, and size of the text.

How to make a header on google sheets on pc or macMaking a custom graphic header

Advanced: To spice up your Google Form header, you can upload a GIF sticker or animate your text layers in the Kapwing Studio. Click “Settings” in the toolbar to change your output type to GIF. Google Forms supports GIF headers, so you can use some animation to add flare to your form. In my example, I made my “Hello” text flicker in.

Once you’re done with your design, click “Publish” to get the output. After Kapwing processes your design, you can download the JPG or GIF file to your computer. If you’re not signed into a Kapwing account, sign in or sign up using your Google or Facebook account – once you’ve signed into a Kapwing account, the watermark in the lower right corner will be removed from your final image.

Upload it to your Form

When you’re the editor for a Google Form, you can click the paint pallet tool to open the style options.

How to make a header on google sheets on pc or mac

From the “Theme Options” panel, form editors can change the colors and font styles and can upload an image for the Header. Click to upload the image you downloaded from Kapwing.

How to make a header on google sheets on pc or macGoogle Forms upload panel

Then, click “Upload photo” and drag the file or choose it from your computer. After you’ve upload the image to your header, preview your Google Form to see what the image looks like.

How to make a header on google sheets on pc or mac

Thanks for reading! I hope this article helps you create better header images for Google Forms. Kapwing’s Studio is a free online tool.

Subscribe!

Hear more about our journey as a scrappy media startup.

Julia Enthoven

CEO and co-founder of Kapwing. Here to help you be more creative!