Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to edit spreadsheet?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 26-06-2011
Member
 
Join Date: Aug 2010
Posts: 61
How to edit spreadsheet?
  

Hi I have been using Excel 2010 and I wanted some information regarding it. I
I have my worksheet saved on Excel 2010 which is completely filled in over time, I had filled it so that I can keep some rows always blank. Now I wanted to do some edition as I want to take a value from a cell in the last row to fill it and place it in a cell in a new spreadsheet or in some other words, I want it to be the last non-blank cell in that particular column. I tried doing this but was not able to do it so I thought to take a help from you guys.

Reply With Quote
  #2  
Old 26-06-2011
Member
 
Join Date: May 2008
Posts: 979
Re: How to edit spreadsheet?

Do you want to edit your spreadsheet manually? As you can do it automatically instead of entering data manually. There is a feature called as Auto Fill, you can fill cells with the data that is based on data in other cells or that has a pattern. I can give you information on Auto Fill, as I don?t know much about how to enter data manually or enter data simultaneously on various spreadsheets/worksheets.
Reply With Quote
  #3  
Old 26-06-2011
Member
 
Join Date: Nov 2008
Posts: 996
Re: How to edit spreadsheet?

There are many options if you want to enter (edit) the data manually in worksheets. You can enter (edit) data in one cell, in a number of cells at the same time, you can also add more than one worksheet at a time. You can enter numbers, text, dates, times, etc as your data in your worksheet. You can even set different ? different formats for it. And, there are a number of settings that by which you can make data entry quite easier to enter.
Reply With Quote
  #4  
Old 26-06-2011
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: How to edit spreadsheet?

You can try the look up function where you can enter the data on your worksheets all at a time.

=LOOKUP(2,1/(Sheet2!A1:A65535<>""),Sheet2!A1:A65535)

As you are looking for entering the data to the last cell in column A on sheet 2 that has the data in it.

I have been using Excel 2003 on my computer. It will defiantly work on your Excel 2010.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to edit spreadsheet?"
Thread Thread Starter Forum Replies Last Post
Is Spreadsheet available for Cityville Licka Boy Video Games 4 02-02-2011 10:25 AM
Spreadsheet vs Database Lishi Windows Software 3 01-09-2009 10:04 AM
Importing Excel Spreadsheet Theodore Long Microsoft Project 3 05-06-2009 09:02 AM
Corrupt spreadsheet in excel Indrani Windows Software 3 06-05-2009 03:12 PM
Adding commands to "Folder Options/Edit File Type/Actions" grayed-out "Edit" & "Remove" Green_XP Windows XP Support 1 06-11-2007 02:18 PM


All times are GMT +5.5. The time now is 04:31 AM.