Skip to main content

Excel: FAQs

Frequently Asked Questions

The following provides information and links to some of the questions that are frequently asked about Microsoft Excel at the Weigle Information Commons.

How do I change column width and/or row height?

How do I hide or unhide rows and columns?

How do I make the first row or column stay in place while I scroll through my data?

How do I reference a cell that is located in a different sheet?

How do I find duplicate values in my data?

How do I create a data table?

How do I use VLOOKUP?

How do I use Pivot Tables?

How do I find and use keyboard shortcuts?

How do I open files created in newer versions of Excel on my computer?

I can’t find the button for...

How do I download Excel using my Penn O365 account?

Excel for Mac vs. Excel for Windows

How do I get more help with Excel?