Enter your custom list as a table and then go under Data tab and Data Tools section. Select “Data Validation”. In Allow selection choose “List”. Click on the selection “Source” and select your custom list table. Press “OK” if you are satisfied.
Continue readingCategory Archives: MS Office
How to remove all text formatting? | Word 2007
Select all your text and go on to the Home Tab under Font section. Click on “Clear Formatting”. This will clear all the formatting done on selected text. If you have used highlight text tool then these will not be removed.
Continue readingHow to duplicate slides inside a show? | Powerpoint 2007
First select the slide or slides from the Slides menu on the left. Multiple slides can be selected whilst holding down CTRL on your keyboard and pressing once on appropriate slides. Next go under Home tab into Slides section. Click on “New Slide” and choose Duplicate Selected Slides from the down appearing menu. Your slides are now appearing twice in the show.
Continue readingHow to have two workbooks visible at the same time on the screen for editing? | Excel 2007
Open the workbooks you want to edit or view at the same time and go under the View tab. From there choose Arrange All and pick how you want to see both workbooks. With this option you’ll be able to edit, cut, copy and paste both workbooks simultaneously.
Continue readingHow to generate random number? | Excel 2010
Type in „=” and „randbetween”. Then put in brackets and between them the first number is your lowest and second is the highest between which the random number is generated.
Continue readingHow to change list numbering starting number? | Powerpoint 2007
Put your text cursor on the first line. Go on Home tab under Paragraph section. Click on numbering down facing arrow and choose “Bullets and Numbering”. Change the “Start at value” and press “OK”.
Continue readingHow to have two Word documents open for editing in the same window? | Word 2007
First have those two documents open. From one document go under View tab and in Window section choose “Arrange All”. This way you’ll have two documents opened in one window.
Continue reading