Question about Business & Productivity Software

2 Answers

Excel text boxes

Hi. there are cell's that contain thousands of text boxes & makes the excel document very slow to work with. these text boxes are between cells and r too time consuming to delete. what can i do get rid of them. i have checked for viruses but found none. also the text boxes are in different random places.

tanx.

Posted by on

  • zenon01 Feb 16, 2008

    works perfectly. unbelievable response and i am totaly impressed with results.

    thanx one again

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 15 Answers

If you are talking about deleting the text boxes at a time that have been inserted to your cell of excel worksheet, plz follow the steps.
STEP-1
1. Open your excel sheet where the textboxes are inserted.
2. You can click one of the text box (do not click in the cell).Now press control and select the other ones with the mouse.
3. Now press the delete key and your box will be deleted.
else if you want to delete all at a time follow this.
STEP-2
1. Open your excel worksheet that contain text boxes. Now right click on the blank area of Menu bar (At top right corner area). excel text boxes - 5e70363.jpgChoose Drawing tool bar if not selected. Now from the drawing toolbar (above the TASK BAR) choose the --> (arrow mark) at bottom left corner of the drawing bar.
c72d4bc.jpg 2. Now your mouse pointer will be changed to arrow shape. Now click on the bigining of the excel sheet and drag till the page end without releasing your mouse button. Now you will see all the text boxes will be selected.(No text will be selected, Only objects will).
466bdaf.jpg dcf40c0.jpg 3. Now press delete key and all your text boxes will be deleted at a time.

Hope it works, otherwise mail mei will give you the screen shots.

Posted on Feb 16, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 175 Answers

Lost or forgot Word password with which you can acquire the documents or information stored in the Word file is clearly tricky. You can try Word Password Recovery to recover the lost Word password. This would be helpful.
With this practical tool, you can recover and get access to any password-protected Word document at ease. And here is guide for you:
1. Click Open and select the file.
2. Choose one of the attack types to recover Word password.
3. Attack settings.
4. Click Start on the taskbar until the operation is finished.
5. Click OK, and you will find the password in the box. If you still haven't mastered the guide to recover lost Word password, you can click here as the reference.

Posted on Nov 11, 2011

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

Size of the excel file increased from 721 KB to 50MB


Many businesses use Excel to track their data and expenses.
However, you can run into problems when files grow too big.
Try reducing the size of your Excel files in different ways to eliminate your storage problems.
Remove unnecessary graphics and fonts from the Excel file.
Simple report data doesn't need a lot of excess formatting to make it attractive.
If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
Reduce the number of pivot tables you allow in your data analysis.
Run your pivot table wizard when dealing with involved calculations.
When given options to format the file, choose those that allow the data to refresh instead of adding a new table.
Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
To do this, choose "XML Data" in the "Save as type" drop down box.
Change the name of your document as well, so you can tell the difference between the two files.
Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
Check into file compression software such as OzGrid.
These products exist because you cannot open a file once it gets too big.
Compress the XLS data by compelling the program to recalculate the cells used for your file.

Excel File Size Reduce Software 7.0
http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html

http://www.ozgrid.com/

or

Microsoft Excel files can contain thousands of cells filled with data.
When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

1. Click on any cell in the Excel file you want to reduce.
Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
2. Click the "Special" button on the "Go To" dialog box.
Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


3. Go to the very last cell containing data in the Excel file.
Select the entire row beneath this cell by clicking the number to the left of it.
Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
The file size will be listed on the "General" tab.



http://www.ozgrid.com/Excel/ExcelProblems.htm

Apr 22, 2013 | Microsoft Office Professional 2010

1 Answer

Reduce the size of excel file


Many businesses use Excel to track their data and expenses.
However, you can run into problems when files grow too big.
Try reducing the size of your Excel files in different ways to eliminate your storage problems.
Remove unnecessary graphics and fonts from the Excel file.
Simple report data doesn't need a lot of excess formatting to make it attractive.
If you need to keep different fonts in your file, reduce some of the font sizes you originally used.
Reduce the number of pivot tables you allow in your data analysis.
Run your pivot table wizard when dealing with involved calculations.
When given options to format the file, choose those that allow the data to refresh instead of adding a new table.


Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format) file.
To do this, choose "XML Data" in the "Save as type" drop down box.
Change the name of your document as well, so you can tell the difference between the two files.

Open the XML file and save it back into the regular XLS file to create a smaller file than the original.
Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last "save."
Check into file compression software such as OzGrid.
These products exist because you cannot open a file once it gets too big.
Compress the XLS data by compelling the program to recalculate the cells used for your file.


Excel File Size Reduce Software 7.0
http://www.newfreedownloads.com/Business/Spreadsheets/Excel-File-Size-Reduce-Software.html

http://www.ozgrid.com/
or
Microsoft Excel files can contain thousands of cells filled with data.
When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other worksheets, you can end up with an enormous file that takes up precious system space and slows Excel down.
While there are many software programs available that promise to shrink Excel files, there are many ways to reduce the bulk without downloading a new application.

1. Click on any cell in the Excel file you want to reduce.
Open the "Go To" dialog box in Excel 2007 by clicking the "Find" drop-down arrow on the Home tab of the ribbon and selecting "Go To."
In Excel 2003 or earlier, go to the "Edit" menu and select "Go To."
You can also use the keyboard shortcut "Ctrl+G" in any version of Excel.
2. Click the "Special" button on the "Go To" dialog box.
Select "Blanks" and click "OK." Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All." This will clear any blank cells to help reduce the file size.


3. Go to the very last cell containing data in the Excel file.
Select the entire row beneath this cell by clicking the number to the left of it.
Hold "Ctrl+Shift" and then press the down arrow key to select all of the cells beneath this point.

4. Click the "Clear" drop-down in the "Editing" group in Excel 2007 and select "Clear All."
In Excel 2003 or earlier, go to the "Edit" menu, point to "Clear" and select "All."
Select the column to the right of the last cell. Hold "Ctrl+Shift" and then press the right arrow key. Again, select "Clear All."
5. Repeat Steps 1 through 5 for any other Excel files that are linked to the workbook you are trying to reduce.
Save the files and then check the new file size by clicking the "Office Button" in Excel 2007.
Point to "Prepare" and then click on "Properties." In Excel 2003 or earlier, go to the "File" menu and select "Properties."
The file size will be listed on the "General" tab.



http://www.ozgrid.com/Excel/ExcelProblems.htm

Apr 22, 2013 | Microsoft Office Business & Productivity...

1 Answer

My font is Times New Roman 12 point. How do I change that to Times New Roman 14 point and not have to make the change every time I work on a new document?


Sounds like you are working with Word 2007 right? Here are the instructions for making the font what you want automatically when it starts up. From the Microsoft webpage: Set the default font
  1. If your document already contains text that is formatted with the properties that you want to use, select that text.

If you are starting from a blank document, go to step 2.

  1. On the Home tab, click the Font Dialog Box Launcher, and then click theFont tab.

za010176292.gif

  1. Select the options that you want to apply to the default font, such as font style and font size. If you selected text in step 1, the properties of the selected text are set in the dialog box.
  2. Click Default, and then click Yes.

May 18, 2011 | Microsoft Office Word 2007 Full Version...

1 Answer

I AMHAVING MICROSOFT 2003 WORD IT DOES NOT CHECK SPELLING. HOW TO MAKE IT CHECK SPELLING.


Select some text in the document that contains a known mispelling. Under Tools > Language, look at the box for "do not check spelling or grammar." If
it is gray or checked, uncheck it. Run the spell check.

This is a text-specific setting, like bold or italics. It does not apply to
a computer, an instance of Word, or even an entire document. This is
different from the setting under Tools > Options > Spelling and Grammar,
which applies to all documents opened (but does not override the
text-specific settings).

If this is the problem, you can clear the problem up by selecting your
entire document (Ctrl-A) and unchecking the box.

Please, if the problem continues, use Office update, or re-install the product.
Good luck!

Mar 20, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

Text in excel textbox turns to gibberish


It may be a font issue... did you change the font of the typed-in text to a non-True Type face? For every typeface there are two fonts: a screen font to display on your monitor and a printer font for printing,

If somehow there is confusion or corruption in the Excel file contents about exactly which font is specified at a given point in the text box (e.g.if you type like I do with lots of backspaces, which are actually special codes that can cause such corruption), then the misfire between screen and print fonts can cause the text data to be corrupt. It seems to be an operating system issue (did you make a lot of changes to fonts on your system?) or something wrong with your personal installation of Office 2003 in any case, because Excel 2003 is a very stable release. To fix this I would try examining the Windows\Fonts folder using a third-party tool or comparing its contents to a known-good Windows installation (or simply copy and paste your typed paragraphs into Notepad and re-paste it into a new text box in a New Document (starting fresh with a new Excel worksheet could solve it all by itself).

Apr 13, 2009 | Microsoft Excel 2003 (065-03992) for PC

1 Answer

Importing Excel file into Act 2006 Version8


My advice is not specific to Sage, but exoprting Excel data.

Check there are no missing/ blank cells within the range, anything that is blank change it to 0.

Make sure the format of your range matches the character length allowed in Sage - Especially for text - if necessary check the no of characters using =LEN(B2) - Assuming B2 contains the text you are checking, where necessary trim the no of characters.

Change your format to CSV if possible, sometimes easier to import.

If you do the above and receive an error message or can narrow down the issue it will give me a better idea of why the import is failing.

Mar 23, 2009 | Sage ACT! 2006 Full Version for PC

1 Answer

I want to link a word document to a cell in Excel


Dear nshrivas,

Type some text in a cell and select that cell then right click choose Hyperlink option then select the file which you want to link and click ok.....


Thanks,



Sep 24, 2008 | Microsoft Excel for PC

1 Answer

Text will not wrap


Under the format of the cell, wrap text is checked. I believe there is a size limitation of characters to a cell. I believe its 255 characters. You could try using an adjacent cell an use a merge cell format as well as the wrap text by highlight both cells.

Sep 03, 2008 | Microsoft Excel for PC

1 Answer

Excel


First a question - is this school homework?

I ask because I have just spent about 2 hours on creating the answer - there is no function to do this except to convert to text as currency in Thai.

May 12, 2008 | Business & Productivity Software

1 Answer

Excel Coordinates don't show up in Formula Bar


Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.
  1. Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
  2. On the Format menu, click Cells, and then click the Protection tab.
  3. Select the Hidden check box.
  4. Click OK.
  5. On the Tools menu, point to Protection, and then click Protect Sheet.
  6. Make sure the Protect worksheet and contents of locked cells check box is selected.
Good Luck!
Wayne

Dec 28, 2007 | Business & Productivity Software

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

720 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

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

Answer questions

Manuals & User Guides

Loading...