• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Excel / How to Make an Entire Row Yellow in Excel for Office 365

How to Make an Entire Row Yellow in Excel for Office 365

April 24, 2019 By Matt Jacobs

Once you’ve finished adding the data to your spreadsheet, your attention typically turns to making sure that the data is presented in a way that is easy for your readers. Whether this involves changing the font, making the columns and rows bigger, or adjusting print settings, there are a number of different actions that you can take.

One helpful setting you can change is to add a fill color to some of the data that you think is most important for your reader. By adding this fill color you will draw their eyes to a particular cell or set of cells, allowing you to simply the process of reading the data by showing that which is most important. Our guide below will show you how to add yellow fill color to an entire row in Excel for Office 365.

How to Add Yellow Fill Color to a Row in Excel

The steps in this article were performed in the Microsoft Excel for Office 365 version of the application, but will work in most other versions of Excel as well.

Step 1: Open your file in Excel.

Step 2: Select the row number that you wish to make yellow from the left side of the window. I am going to apply the yellow fill color to row 3 in the example below.

select the row to make yellow

Step 3: Click the Home tab at the top of the window.

click the home tab at the top of the window

Step 4: Click the arrow to the right of the Fill Color button, then choose the yellow square from the menu.

how to add yellow fill color to entire row in excel

Is your printed Excel file spilling over on to additional pages because of one or two columns? Find out how to fit all columns on one page and reduce the number of pages needed to print the document.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Delete a Text Box in Microsoft Excel for Office 365
  • How to Add Line Numbers in Word for Office 365
  • How to Save a Picture to Your Computer from Powerpoint for Office 365
  • How to Enable Data Saver in Spotify on an iPhone
  • How to Change the Font for a Selection in Microsoft Word for Office 365

Featured Posts

Does the Amazon Fire Stick Need Internet?

how to download Google Docs as a Word file

How to Download Google Docs as Word

how to turn on data saver in the Spotify iPhone app

How to Enable Data Saver in Spotify on an iPhone

How to Remove All Hyperlinks in Microsoft Word for Office 365

how to disable iPhone data roaming

How to Turn Off Data Roaming on an iPhone 11

How to Close Pandora on an iPhone 7

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com