Excel files are typically saved with the .xls or .xlsx file extension. However, many files that you need to work with in Excel are in the CSV file format, and double-clicking them will open them in Notepad by default (you can read here to learn how to change that.)
Your next step will likely involve opening Excel 2013, then browsing to the CSV file to try and open it that way. However, you might navigate to the folder where the CSV file is located, only to discover that you can’t see it. Continue reading below to learn about the change that you need to make in order to display all of the files that are saved in a folder.
Show All Files in a Folder in Excel 2013
The steps in this article will assume that you have a file that you want to open in Excel, but it is not a file with the extension .xls or .xlsx. This guide will show you a quick change that you can make which will display all of the files that are stored in a particular folder. If you would like to be able to view file extensions more easily in Windows 7, click here to learn how.
Step 1: Open Excel 2013.
Step 2: Click the File tab at the top-left corner of the window.
Step 3: Click Open in the column at the left side of the window.
Step 4: Click Computer in the center column (or you can click one of the other options, if the folder is in a different location), then browse to the desired folder from the options in the right column.
Step 5: Click the All Excel Files drop-down menu at the bottom-right of the screen, then click the All Files option.
You can then view all of the files that are saved in that folder, and double-click any of them to try and open them in Excel. Excel cannot open every type of file, but is able to open many different ones. Click here if you need to open a file that might currently be hidden in a folder.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
|
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.