On the ribbon choose View and under Show section choose Ruler

On the ribbon choose View and under Show section choose Ruler

Protected view can be removed in File > Options > Trust Center > Trust Center Settings… > Protected View
Continue readingFirst select the cells or just one cell depending on whether there’s a specific area you wish to clear from rules or you wish for the whole sheet to be free from formatting rules. Next go under Home tab into Styles section and click on the first button from the row called “Conditional Formatting”. From the down-appearing menu click on “Clear Rules” and “Clear Rules from Selected Cells” or “Clear Rules from Entire Sheet” depending on your preference.
Continue readingLet’s say you have some cells in one column filled with numbers and other cells in the same column are empty. What we want to do now is enter zeros into the cells that are empty. Select the area you want to be filled. Go to the Home tab under Editing section and choose Find & Select. From the drop-down menu choose “Replace …” Into the “Find what” do not enter anything and into “Replace with” enter a zero. Now press the “Replace All” button.
Continue readingGo under Picture Tools and Format tab under Adjust section and click on “Recolor”. From the down appearing menu choose the second option under Color Modes called “Sepia”. Click on the small image and notice how your image changes.
Continue readingGo under Picture Tools and Format tab under Adjust section and click on “Recolor”. From the down appearing menu choose the first option under Color Modes called “Grayscale”. Click on the small image and notice how your image changes.
Continue reading