Skip to main content
Click logo to go to Libraries homepage

Excel: FAQs

For more help...

For general assistance, please contact
Weigle Information Commons
Email Us
215-898-7555

For project help, consultations or group instruction for patrons in the Health Sciences, please contact
Barbara Kountouzi
Biomedical Library
varvarak@upenn.edu
215-898-6978

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?