Queens College Helpdesk

Conditional formatting provides visual cues to help you quickly make sense of your data. For example, it’ll clearly show highs and lows, or other data trend...

If you want to change the way data appears in a cell, you can rotate the font angle, or change the data alignment. Align a column, or row Select a c...

You can apply formatting to an entire cell and to the data inside a cell—or a group of cells. One way to think of this is the cells are the frame of a pictu...

Copy cell formatting in your worksheet using copy and paste options, Format Painter, and dragging techniques. Select the shape, text, picture, or works...

Microsoft Excel doesn’t come with a built-in watermark button. But you can use an image, like a logo, to create a watermark. Create a watermark Sele...

You may have a personal preference to display zero values in a cell, or you may be using a spreadsheet that adheres to a set of format standards that requir...

Create and build a custom numeric format to show your numbers as percentages, currency, dates, and more. To learn more about how to change number format cod...

Get started on how to create formulas and use built-in functions to perform calculations and solve problems. Create a formula that refers to values in ot...

Use VLOOKUP when you need to find things in a table or range by row. Select a cell. Type =VLOOKUP( and then select the value to lookup. Type a ...

 The SUM function, one of the math and trig functions, adds values. You can add individual values, cell references or ranges or a mix of all three. For ex...