Selecting the whole worksheet ensures you won’t accidentally miss something. With the entire worksheet selected, you can copy it from one workbook (XLS file) and then paste it into a worksheet in a different workbook. Why would you want to select the entire worksheet? Let’s count some of the ways: As shown in Figure A, it’s the space above the row numbers and to the left of the column letters. The next time you need to select an entire worksheet, click the little gray box in the top-left corner of the sheet. This post originally appeared as an article and is also available as a PDF download. These tips apply to Excel 2003, although most of them work the same way in earlier versions of Excel. If you (or your users) perform certain tasks every time you use Excel, you’ll want to make sure you’re taking advantage of these time-saving shortcuts. However, buried within Excel are lots of cool features that too few users have discovered. Over the years, each new version of Excel has introduced some nifty features. Here are some highly useful tips that can streamline typical tasks and boost productivity. Some Excel users waste a lot of time (and add to your support burden) because they don't know the smartest ways to work with spreadsheet data. 10 obscure Excel tricks that can expedite common chores
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |