Question about Microsoft Excel for PC

1 Answer

Cells becoming blank, deleting on their own

I have a curious problem since I upgraded to Excel 2007. I will be editing the spreadsheet making changes as normal. I will go away from my desk for a while and when I return the cell where I last edited is now blank. I have to do an Undo to get the text back. This occurs 10-15 times a day and is very anoying.
There are no calculations going on, only simple text in the cells. Could this be a problem with our network? I continually have to save before I get up from my desk just to be sure I don't accidently forget to 'Undo' before typing anything new when I sit back down at my desk.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 53 Answers

Do you have a touchpad on your laptop? I don't know if this is your problem, but I used to have the exact same issue with a new laptop with a sensitive touchpad. Without realizing it, after my last keystroke, I would slightly touch the touchpad with my wrist when I left the desk, which then moved the cursor to another cell, which caused the last cell entry to get deleted.

Posted on Jul 15, 2008

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:

1 Answer

Excel table link in word


Excel and Word are two parts of the Microsoft Office Suite that have become standards tools for spreadsheets and word processing.
Among their features are the ability to easily exchange information.
For example, you can easily copy a cell or part of a spreadsheet from an Excel and paste it into a Word document, which preserves all the formatting.
This method requires opening up both programs at the same time.
To avoid this, you can insert an Excel file from within Word itself.

Choose the "Insert" tab inside Microsoft Word to display the Object dialog box.
Click the "Create from File" tab and Browse to display the Browse dialog box.
Navigate to the Excel file that you need and double-click to load its name into the File Name box of the Object dialog box.

Click a checkmark into the "Link to File" box if you want the table that you insert to be automatically updated anytime the original file is changed.
Otherwise, leave it blank if you don't want the inserted information to be affected by the original file.

Click "OK" to insert the Excel file as a frame into the document.
Note how only filled cells from the first table (worksheet) of the file are inserted.
Blank cells are not inserted. You can resize the frame by clicking it and dragging the handles that appear.
You can also click it and drag it to a different line within the document.


http://office.microsoft.com/en-us/word-help/link-or-embed-an-excel-worksheet-HA010120810.aspx - BM4

Aug 07, 2013 | Microsoft Excel Computers & Internet

1 Answer

Excel to word tables linking


Excel and Word are two parts of the Microsoft Office Suite that have become standards tools for spreadsheets and word processing.
Among their features are the ability to easily exchange information.
For example, you can easily copy a cell or part of a spreadsheet from an Excel and paste it into a Word document, which preserves all the formatting.
This method requires opening up both programs at the same time.
To avoid this, you can insert an Excel file from within Word itself.

Choose the "Insert" tab inside Microsoft Word to display the Object dialog box.
Click the "Create from File" tab and Browse to display the Browse dialog box.
Navigate to the Excel file that you need and double-click to load its name into the File Name box of the Object dialog box.

Click a checkmark into the "Link to File" box if you want the table that you insert to be automatically updated anytime the original file is changed.
Otherwise, leave it blank if you don't want the inserted information to be affected by the original file.

Click "OK" to insert the Excel file as a frame into the document.
Note how only filled cells from the first table (worksheet) of the file are inserted.
Blank cells are not inserted. You can resize the frame by clicking it and dragging the handles that appear.
You can also click it and drag it to a different line within the document.


http://office.microsoft.com/en-us/word-help/link-or-embed-an-excel-worksheet-HA010120810.aspx - BM4

Aug 07, 2013 | Microsoft OFFICE 2013 HOME AND BUSINESS 1...

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

1 Answer

I can't get Microsoft Excel 2003 to delete cells


Hello,

Unless the excel spreadsheet is locked for editing then all you should have to do is Left Click on the cell you want to delete and press Backspace or the DEL key on your keyboard.

To delete multiple cells left click and hold in the middle of the first cell and drag your mouse down or across to highlight multiple cells. Then press the Backspace or DEL key on your keyboard.

Feb 11, 2012 | Microsoft Office Excel 2003 for PC

1 Answer

When using Mail Merge, how can you make Word 2007 ignore any Blank cells in Excel 2007?


  • Open the Microsoft Excel 2007 spreadsheet file on your computer that contains the blank cells that you want to merge.

  • 2

    Use your mouse to select the adjacent blank cells that you want to merge together. The cells you want to merge should then be highlighted in blue.

  • 3

    Click on the "Home" tab and then click on the "Merge and Center" option from the "Alignment" group. The blank cells will all be merged and centered.

  • 4

    Click on the arrow next to the "Merge and Center" option and then click on the "Merge Across" option if you don't want the blank cells centered.

  • 5

    Select the merged cells and then click on the "Merge and Center" button again at any time to split the cells.

  • Mar 07, 2011 | Computers & Internet

    1 Answer

    Hi, I am trying to change an excel spreadsheet. There are unit numbers on the spreadsheet which have converted themseles to dates ie 4/52 has now become Apr-52. I have tried everythiong to change it but...


    Right-click the cells and go to 'Format Cells'. Then, select the correct format. If you're wanting to leave the slash (/) in the number, you'll probably have to make it a text format.

    Dec 22, 2010 | Microsoft Computers & Internet

    1 Answer

    How to delete the nulls cells?


    Try create a new Workbook (file) and then copy only the 10x200 cells from the NULL'ly spreadsheet. Unless you have macros in the nully one, it should be resolved by copying the needed cells to blank new file.

    Apr 17, 2009 | Microsoft Computers & Internet

    Not finding what you are looking for?
    Microsoft Excel for PC Logo

    46 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2642 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18375 Answers

    Brian Sullivan
    Brian Sullivan

    Level 3 Expert

    27725 Answers

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

    Answer questions

    Manuals & User Guides

    Loading...