Resizing Excel Columns, Duplicating Objects in PowerPoint, and Adding More Levels of Undo
This week, we have a hodgepodge of various shortcuts in Microsoft Office.First off,
Resizing Excel Columns to Fit Text
In Microsoft Office Excel, you can resize multiple columns to different widths so that you can see all the text in your spreadsheet.
1. Select the columns where your text appears by clicking the column headings. Select multiple columns if necessary.
2. To resize the columns to fit, double-click in the header, in between two columns.For example, if your text is in column A, click where the red circle is in the example to the right.
All of your selected columns are resized based on the longest text string in each column. In this way, a large and confusing spreadsheet with lots of text that you can’t see is converted into a legible spreadsheet with all text showing.
Taking a break from Excel for a while…
Duplicating Objects and slides in PowerPoint
You can quickly duplicate objects and slides, by placing your mouse over a
n object. Press the CTRL key and you’ll see the mouse with a “+” sign. Then click and drag the object where you want it to be. You can do the same for slides in the viewer modes. Just CTRL click and drag the slides.
Another option is to select a slide or object and press CTRL+D. That duplicates the object.
Add More Levels of Undo in PowerPoint
You can go back farther in Microsoft Office PowerPoint to undo actions.
1.With PowerPoint open, click the Office button, and then click PowerPoint Options at the bottom of the pull-down menu.
2.On the Advanced tab, change the Maximum number of undos from the default 20 to any number from 3 to 150.
That’s all for now.Until next week,
The elite Program
Follow
Comments are closed.