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

For project help, consultations or group instruction for patrons in the Health Sciences, please contact
Barbara Kountouzi
Biomedical Library

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?