Posted by kashaan143 on September 19, 2008
A while ago, we showed you how to copy data from one sheet to another. You simply hold down the Alt key while you drag the cell or cells to the appropriate sheet tab at the bottom of your screen. Excel automatically jumps to that sheet and continues to drag the data to its new home in the target sheet.
You can also use the Alt key while dragging data to prevent the sheet from scrolling. If you’ve ever had to drag data right to the edge of the worksheet, you already know that Excel can overreact and send you scrolling into oblivion. Holding down the Alt key allows you to move a block of data right to the edge without all that trouble.
Posted in MS-Office Tips & Articles | Tagged: alt, another, automatically, cell, cells, continues, copy, data, drag, dragging, edge, excel, excel tips and articles, from, holdin, key, ms-office articles, ms-office tips, ms-office tips and articles, ms-office tips and tricks, prevent, Prevent Your Sheet from Scrolling, right, screen, scroll, scrolling, sheet, target, top excel tips, trouble | Leave a Comment »
Posted by kashaan143 on September 17, 2008
If you’d like to see a quick list of the sheets in the current workbook, simply open the file’s property dialog box. To do so, choose File, Properties. Then, click the Contents tab, and Excel will display a complete Complex workbooks usually contain several worksheets, and keeping up with all those sheets can be a list of sheets in the current workbook.
Posted in MS-Office Tips & Articles | Tagged: application name, complete complex, contents, current, dialog box, display, excel, file, How Many Sheets, keeping, microsoft office tips, microsoft office top articles, ms word tips and articles, properties, propery, sheets, top ms word tips, usually, word tips, workbook | Leave a Comment »
