Question about Computers & Internet

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

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

Tip

Rotating Text in Cells


In Excel, text of cells can be rotated to any direction or to a certain angle. It is called the orientation of the text. By default, orientation of text is horizontal.
To change the orientation of text, follow these steps.
  • Select cell or range of cells that contains data you want to rotate.
  • Select ”Cells” command from “Format” menu OR Press Ctrl+1, Format Cells dialog box appears.
  • Click Alignment tab of dialog box.
  • Specify angle in ”Degrees” spin box of orientation section.
  • Click “OK” button of dialog box.

on Jan 29, 2010 | Computers & Internet

Tip

Microsoft Excel tips


Auto sum shortcut key
Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .
Create hyper links in Excel
Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing "CTRL + K".
Close all open files at once
Close all open Microsoft Word and/or Excel files by holding down the shift key and clicking "File" and then "Close All".
Quickly open recently opened files
Quickly open the recent files by first pressing "ALT + F" to open the file Menu and press 1, 2, 3, or 4.
Create underlines without any text
This tip works with the majority of Microsoft Office applications. Easily create an underlined space by pressing CTRL + U to start the underline, then press SHIFT + Space for each underlined space you wish to create. An example of how this could be used is for printable forms, for example: Name: .
Print only sections of a document
Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click print. In the printer dialog window under Page Range choose the option Selection. It is important to realize that not all programs or printer drivers support this feature.
Repeat recent action
Using the F4 key in Microsoft Office 2000 and above allows the user to repeat the last used action. For example, if you have changed the font of a selected text and wish to change another portion of text to the same font, pressing F4 will do this for you automatically.
Quickly undo
Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.
Quickly above cell contents
In Microsoft Excel press CTRL + SHIFT + " to copy the above cells contents.
Using the Microsoft Excel Auto filter
Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be easily sorted by using the Auto filter option, to use this option select the top rows of the columns you want to be used and select Data / Filter and Auto Filter. Once successfully completed you can use drop down arrows to filter the data automatically.

on Dec 27, 2009 | Computers & Internet

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 Computers & Internet

2 Answers

How to save excel data in a text file from excel


To save an Excel document as a .TXT file, follow the steps below:
1. Click on "File" from the Menu Bar 2. Click "Save as" 3. A new window will appear, in the box title "File Name", give the document a name. 4. In the box titled, "Save As Type", click on the drop-down arrow and select "Text (Tab Delimited) (*.txt)" 5. Click "Save"

Aug 14, 2010 | Microsoft Computers & Internet

Tip

How to protect MS Excel file using password?


In Microsoft Excel, you can protect a single cell, group of cells on a worksheet or an entire workbook by applying password so that unauthorized person can not display as well as modify your document. You can apply two types of password.
Password to open the document:
If it is applied then you have to give the correct password to open the workbook. Otherwise you cannot open the workbook.
Password to modify the document:
If it is applied then you have to give the correct password to modify the workbook. Otherwise your workbook is opened but you cannot modify the workbook. It means that your workbook becomes read-only.
To apply a password to MS Excel document, follow the given steps:
First click on "Tools" menu and select the "Option" from drop down menu.
A windows dialog box will appear, here select the "Security" tab.
Enter first password in "Password to open" text box under "File encryption settings for this workbook" section and second password in "Password to modify" text box (if required) under" File sharing settings for the workbook" section then click "Ok" button of dialog box.
Microsoft Excel will open "Confirm Password" dialog box for the confirmation of passwords. The maximum length of password is 15 characters.
Re-enter the password to open and password to modify and click "Ok" button of Confirm Password dialog boxes one by one.
Now close the file and then reopen to test the password.

on Dec 03, 2009 | Computers & Internet

1 Answer

How to use document viewer in samsung star wifi


document viewer, can be use to view documents such as word, excel, or text notes (notepads). if you received a files containing excel or word, then you can use this to view it.

regards.

Mar 03, 2010 | Samsung Star GT-S5233 Cell Phone

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

Need Formula


TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $

IMPORTING
Import SQL Into Excel-SQL Tester $
Import Excel Into Access $

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

1 Answer

Dreamweaver CS3


Import Microsoft Office documents (Windows only) You can insert the full contents of a Microsoft Word or Excel document in a new or existing web page. When you import a Word or Excel document, Dreamweaver receives the converted HTML and inserts it into your web page. The file’s size, after Dreamweaver receives the converted HTML, must be less than 300K.
Instead of importing the entire contents of a file, you can also paste portions of a Word document and preserve the formatting.
Note: If you use Microsoft Office 97, you cannot import the contents of a Word or Excel document; you must insert a link to the document.
  1. Open the web page into which you want to insert the Word or Excel document.
  2. In Design view, do one of the following to select the file:
    • Drag the file from its current location to the page where you want the content to appear.
    • Select File > Import > Word Document or File > Import > Excel Document.
  3. In the Insert Document dialog box, browse to the file you want to add, select any of the formatting options from the Formatting pop-up menu at the bottom of the dialog box, and then click Open. Text Only Inserts unformatted text. If the original text is formatted, all formatting will be removed.
    Text With Structure Inserts text that retains structure, but does not retain basic formatting. For example, you can paste text and retain the structure of paragraphs, lists, and tables, without retaining bold, italics, and other formatting.
    Text With Structure Plus Basic Formatting Inserts both structured and simple HTML-formatted text (e.g., paragraphs and tables, as well as text formatted with the b, i, u, strong, em, hr, abbr, or acronym tag).
    Text With Structure Plus Full Formatting Inserts text that retains all structure, HTML formatting, and CSS styles.
    Clean Up Word Paragraph Spacing Eliminates extra space between paragraphs when you paste your text if you selected Text With Structure or Basic Formatting. The contents of the Word or Excel document appear in your page.
Source: Dreamweaver CS3 Help

Feb 06, 2008 | Adobe Photoshop 7.0 for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

724 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18384 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...