DocHub is an all-in-one PDF editor that enables you to shade logotype in xls, and much more. You can underline, blackout, or erase paperwork components, add text and images where you want them, and collect data and signatures. And because it works on any web browser, you won’t need to update your device to access its powerful features, saving you money. With DocHub, a web browser is all you need to process your xls.
Sign in to our service and adhere to these instructions:
It couldn't be easier! Enhance your document processing today with DocHub!
hi friends in this video let us see how to shade alternate rows in excel this will make your data more presentable and readable this is a sample data that i consider now as an example first let us see the first method of course the simplest way to shade the alternative rows is by converting this data range to a table just place your cursor anywhere within the range and press keyboard shortcut ctrl d create table window will pop up with the row selection like this and click the ok button to apply table format on the selected rows you can create a custom design by going to the design tab so this is the advantage of using this table method now let us see the second method select the rows without the header row click on the conditional formatting dropdown under the styles group select new rule in the new formatting rule dialog box under select a rule type option select user formula to determine which cells to format rule type the formula as equals to mod open the parenthesis row open paren
