Question about Microsoft Office Standard for PC

1 Answer

Excel documents into folders

I'm trying to move Excel documents into a folder. Click and drag does not work. What should I do?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 21 Answers
Re: Excel documents into folders

1. create a new folder (wherever) 2. highlight all the documents 3. right-click and select "cut" 4. go to folder, right-click and select "paste" pretty basic stuff.

Posted on Oct 03, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Hyperlink other document in excel button

The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.

If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:

Folder name Filename Concatenated LINK ../excel/ file1.pdf ../excel/file1.pdf file1.pdf ../excel/ file2.pdf ../excel/file2.pdf file2.pdf ../excel/ file3.pdf ../excel/file3.pdf file3.pdf

Here are the formulas behind this:
A B C D Folder name Filename Concatenated LINK ../excel/ file1.pdf =CONCATENATE(A2,B2) =HYPERLINK((C2),B2)
../excel/ file2.pdf =CONCATENATE(A3,B3) =HYPERLINK((C3),B3)
../excel/ file3.pdf =CONCATENATE(A4,B4) =HYPERLINK((C4),B4)
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).

Feb 21, 2014 | Microsoft Excel for PC


Top 10 most useful secrets in Office

Here are my top 10 most useful secret ninja moves to increase your productivity and win friends and lovers.
#1: Format painter (Office) The Format Painter tool replicates the formatting from one part of a document to another. So instead of manually redoing all the formatting yourself, you can use the Format Painter. First, select the text whose formatting you want to replicate. Then, click the Format Painter toolbar button. Finally, select the text you want to imbue with the format. For bonus points, you can double-click the Format Painter button to replicate the formatting to multiple areas of the document!

#2: Paragraph in/out/up/down (Office) You can easily move a paragraph in four directions by pressing Alt+Shift+[Arrow]. To increase or decrease the indentation level of a paragraph or bullet point, press Alt+Shift+Right and Alt+Shift+Left respectively. To move a paragraph up or down, press Alt+Shift+Up or Alt+Shift+Down. This works especially well in PowerPoint, where it's common to reorder bullet points or change indentation levels.
#3: Increase or decrease font size (Office) To quickly increase the font size of selected text, press Ctrl+Shift+>. To decrease the size, press Ctrl+Shift+<. I find it easy to remember these keyboard shortcuts because the one with the greater-than symbol increases the font size while the less-than symbol decreases it.
#4: Quick Access Toolbar (Office) Office 2007 has a Quick Access Toolbar that can be customized to include buttons for your favorite commands. The Quick Access Toolbar is in the top left corner of many Office applications. You customize it by clicking on the drop-arrow on its right.

#5: Fill handle (Excel) Excel can auto-fill cells in eerily smart ways. Instead of manually typing a sequence in cells, you can simply type the first few values of the sequence and drag the fill handle to auto-fill the rest of the cells. The fill handle is the little black square at the lower right corner of a selected cell's border. Drag it to automatically fill adjacent cells.

If you drag the fill handle with only one cell selected, it will repeat that cell's value into adjacent cells. However, if you drag the fill handle with multiple cells selected, Excel is smart enough to figure out the series. For instance, in the following example, Excel will fill subsequent cells with the increasing series of odd numbers. This even works for other types of series, like dates and percentages.

#6: Moving and copying cells by dragging selection borders (Excel) Quite possibly the most useful yet completely undiscoverable feature in Excel is the ability to move and copy cells by dragging selection borders.

For instance, to move row four between rows one and two, select row four and drag the selection border while holding down the Shift key in order to insert it in its new position. If you drag the border without holding down the Shift key, the selected cells will instead replace the cells you drop them on. Conversely, if you hold down Ctrl while dragging a selection border, the selected cells are copied to their new location.
#7: Status bar statistics (Excel) The status bar in Excel shows handy statistics when multiple cells are selected. In Excel 2007, the status bar shows the selected cells' average, count, and sum. This is an easy way to quickly analyze data without authoring formulas.

#8: Clear formatting (Word and PowerPoint) To remove formatting from selected text, press Ctrl+Spacebar.
#9: Advanced field search (Outlook) In Outlook, you can quickly search through a mail folder by using the Instant Search box. In addition to searching for keywords, you can do a fielded search by prefixing your search text with a variety of field names.

For instance, the above example searches for all mail from people named "jimmy" sent in May with attachments that have "jpg" in the filename. I most often use this feature for two things: to easily find email from a specific person, and to find specific attachments.
#10: Presenter view (PowerPoint) PowerPoint has for many years had a great feature called Presenter View, which allows you as the presenter to see a different view of the presentation from your audience. In Presenter View, your monitor shows not only the slides, but also your notes as well as the current elapsed time in the presentation. This makes giving a presentation far easier. To enable Presenter view, go to the Slide Show ribbon and check Use Presenter View. In that same section, you can also change the monitor which the presentation is shown on. One note: the Use Presenter View checkbox can only be checked if you already have a second monitor connected and enabled.

on Dec 29, 2009 | Business & Productivity Software

1 Answer

I was using gmail; opened excel file; made changes and saved now i can't find the document. Help!

If you clicked "Save" not "Save As", the file is likely in your temp files somewhere.

The method to find the file is tedious - but if it is on your computer - this will find it.

Click Start>Search for Files or Folders and then under the When Was it modified - put in the date range for when you saved the file.

Next - in All of Part of the File name type: *.xlsx

Next - In Look In - make sure to choose the whole C Drive.

Next - In More Advanced options, make sure to check the System Folders, Hidden Files and Folders, and Subfolders.

Then click search.

If the Excel file is on your computer - this search should locate it.

Nov 03, 2011 | Microsoft Office Professional 2007 Full...

2 Answers

How to insert the rupee symbal in excel

Let me add with a brief details on how to download, how to install and how to type Indian Rupee Symbol:
Click here to download INR Rupee font, download this, extract the font file (once you open the zip file, you'll see a file name "Rupee"), copy it and paste it in the Fonts folder of the Control Panel of your computer.
Open a word processing program like Ms-word (in your case, Excel) and select the font as "Rupee" from the drop down lists, now press

on the keyboard.
You'll see the Rupee symbol :

Good luck.
Thanks for using FixYa.

Jul 21, 2010 | Microsoft Excel for PC

1 Answer

Excel file is not opening by double click

Hi there and welcome at Fixya, the support team (lfete)

You have to highlight the file- right click on it- choose open with- here you find the Excel program, check the mark to open the file every time with this program and then choose apply/ok.

If you not find Excel in the overview you have to browse to the folder where the excel program is and choose the file"excel.exe" (program). The folder you normally find in C:\Programs\Office\excel , then follow the rest of the explain above this.

Hope it helps
IF NOT then try to return here

Have a nice time over there

Please rate my answer

Mar 11, 2010 | Microsoft Office 2007 Basic for PC

2 Answers

Please give me detail steps involved if you were able to successfully use this mehod to convert files....

Say you got tons of Excel sheets, PowerPoint presentations and Word documents on your computer that were written in Office XP or 2003. How do you convert all these files to the new Office 2007 format. One option is that you open all of them in the associated Office program and manually save them in the newer (docx, xlsx or pptx) format. Or follow these steps and convert all documents in one go.
Step 1: Download Migration Manager kit and extract it into a new folder – say: c:\office.
Step 2: Download and install the Office Pack – this step is required even if you have Microsoft Office 2007 already installed on your computer.
Step 3: Assuming that you extracted the Office Manager files in c:\office directory, go c:\office\tools, open ofc.ini using notepad and add the following line.
This refers to the folder location that holds your office files. I am pointing this to my Documents folder but it could be different on your machine.
Step 4: Open command prompt and go to c:\office\tools. There you’ll see a utility called ofc.exe – this is the Office File Converter that will convert all old Office files to the new 2007 Office document format in bulk. Run.
Immediately all old Office files in that folder (and sub-folders) will get converted to the new format and are saved in a new folder.
This utility works with Word (doc to docx), Access databases, PowerPoint (ppt to pptx), Visio diagrams, Excel (xls to xlsx) and Microsoft Project files. The conversion may however fail for password protected documents.

Nov 20, 2009 | Microsoft Office 2007 Basic for PC

1 Answer

Our memory is almost out on our computer so we need to move all video and photo files onto another hard drive. Is there any way to relink photos and video without doing each one individually? When I tried...

Two restored down screens is the best way, the files/folders on the left, the device's screen on the right, click on the folder(s) you want, click (Cntrl + A for all folders) and drag it to the storage device's screen

Sep 26, 2009 | Individual VideoShow Expressions (3314)

2 Answers

MS Office 2003 Intallation

Go to "FILE", "Save As" and then change "Save As type to XLS" That should hold that setting afterwards from now on.

<img src="">

If you have any more questions please feel free to email me and don't forget to rate.



Feb 23, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Microsoft excell

If you go to MY RECENT DOCUMENTS, (it should be in C:\\Documents & Settings) you chould see the Excel document that you are trying to open. Double click on that document and it should open.

Another way to get the document open is to do a search. Go to START, Search, For files and folders. Type in the name of the document you want to open and then you can open it as described above.

Hope this helps Loringh

Nov 04, 2008 | Microsoft Office 2000 Premium Service Pack...

3 Answers

Excel working

there are programs available in the net that can retrieve password of excel sheet..some are free and some are not. try searching the net.

Oct 26, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

34 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides