Question about Microsoft Computers & Internet

1 Answer

How to delete the nulls cells?

I use windows xp home edition / microsoft works spreadsheet 7. 
This is a part of my publication which needs to go online But I need only 10 colums and 200 rows but there are thousands in the blank sheet. I have entered all the data properly but I can't get rid of the null cells. I tried delete rows / columns; I tried Clear rows / columns. But nothing happens. Null cells reappears !!!
Please help Many thanks in advance

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Scholar:

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

  • Expert
  • 88 Answers

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.

Posted on Apr 17, 2009

Ad

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

3 Answers

Need password for Microsoft 10


You shouldn't need any password for Windows 10. If you are getting that you have downloaded the wrong version. If you are a Windows 7 user make certain you are only downloading the version of 10 that matches the Windows 7 you currently have. So if you have Windows 7 Home download Windows 10 Home. If you try and download any other type IE Professional - then you will get asked for a password. Which you will have to pay for from Microsoft.
Windows XP is not compatible with Windows 10. If you are using a computer that uses Windows XP and you can't upgrade your computer to Windows 7 or 8, then you will NOT be able to run Windows 10 on it.

Nov 13, 2015 | Microsoft Get Genuine Kit for Windows XP...

Tip

Denied Access to the Desktop in Windows XP then take ownership


Logon as Adminstrator and take ownership of the All Users Desktop folder using this method

b8c3f72.jpg

Home Edition
By default you need to logon with the safe mode to get to the Adminstrator account in the Home Edition however you can add this account to the welcome screen using this reg tweak HERE at my Sky Drive Public.
Microsoft also tells you that you can't access the security tab in Windows XP Home, well you can if you use this simple PATCH download this from my Sky Drive .It can also be done using the Fajo XPSFE tab installer he has a few other goodies up his sleeve check his website HERE for this and much more the file renamer is a great little tool.

Professional Edition
You will need to disable simple file sharing that is tuned on all PC's that are not part of a Network or Domian you don't need to this in the Home Edition its only for the Professional version,Microsoft have there own FIX to do this for you, the Security tab that you need to access is already there all you need to do is click the advanced button shown in red

9caa536.jpg


then select the user to take ownership as shown in the first screendump




on May 04, 2010 | Microsoft Windows XP Home Edition

2 Answers

Need to download a free copy of windows xp home edition from windows 7 laptop ..please help!!


Microsoft makes it available as a download so that people can fix computers that don't have a working CD/DVD drive. You'll still need your registration key, of course, from your original install. Look for a sticker on your computer with the 25-character code. Here is the link for you. Windows XP Home Edition with Service Pack 2 Utility Setup Disks for...

Oct 21, 2013 | Dell Microsoft Windows XP Home Edition

2 Answers

I have have downloaded the HP Laserjet 3015 Print driver on my Lenovo U330 Laptop with Windows 7 Ultimate. Unfortunatley, I've tried 2-3 times to with no success. Am I having a compatiblity issue with...


File name: s.gif upd-5_1_1_8232-pcl5_winxp-vista-x64.exe [1/1, 15.21M] System requirements: s.gif Client and server operated systems supported for the most current release of the UPD:
Client operating systems supported:
  • Microsoft Windows 7 Starter, Home Premium, Professional, Enterprise, and Ultimate; x86 and x64
  • Microsoft Windows Vista Business, Enterprise, Home Basic, Home Premium, and Ultimate; x86 and x64
  • Microsoft Windows XP (SP2 and later) Home Edition, and Professional; x86 and x64
    *Note: Microsoft retired mainstream support for Windows XP in April 2009. HP will continue to provide best effort support for the current UPD and tools for the discontinued Windows XP operating system until 2011

Oct 25, 2010 | HP LaserJet 3015 All-In-One Printer

2 Answers

Microsoft Windows XP Home Edition Reinstallation CD SP1A (B2490): i lost my microsoft windows xp home edition cd...


Usually you can call Dell or HP or whomever sold you the computer and request replacements. These are usually free or available for a small fee.

May 18, 2010 | Dell Microsoft Windows XP Home Edition

1 Answer

Working in a spreadsheet I want freeze column A, so that the rest of the sheet move horizontaly. working in quattro pro 10, I want column A to not move while I scroll left and right ith the rest of the...


In Excel and even Mac Numbers, these columns can be locked and shifted around with ease by accessing the Edit > Lock feature.

In quattro pro...no idea. This was made almost 9 years ago...might be time to upgrade to something a bit more full featured.

Nov 23, 2009 | Microsoft Windows XP Home Edition

3 Answers

Windows 7 beta incompatible??


I have used acronis and win 7 with no issue.

Be aware though that win7 beta has a lot of versions so one may work fine and another maybe not.

As a Technet member I have the latest version and proper key etc.

Pirate versions may be subject to virus and other unwanted side effects.

Sep 11, 2009 | Acronis True Image Home 2009 Full Version...

1 Answer

Works suite 2006 spreadsheet


THERE MAY BE ERROR IN OFFICE INSTALLATION SO PLZ UNINSTALL YOUR OFFICE AND REINSTALL THE OFFICE

Mar 02, 2008 | Microsoft Windows XP Home Edition

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

Related Topics:

102 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Alun Cox

Level 3 Expert

2678 Answers

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

Answer questions

Manuals & User Guides

Loading...