How many worksheets can you make in Microsoft Excel 2007?
As many as the memory in your computer can store. The number of worksheets in each workbook is limited only by the amount of memory available.
5 people found this useful
There are lots of ways to insert a new worksheet. One way is to goto the Insert menu and pick Worksheet on the older versions ofExcel. On the newer versions, you will find it …under Insert on theHome tab of the ribbon. Another way is to right click on anexisting worksheet tab and pick Insert from the pop-up menu. Afterthe last tab there is also an Insert Worksheet tab to click. Youcan also do it by pressing Shift-F11.
That depends on the version you have. Up to and including Excel 2003, the standard amount of columns has been 256 and there has been 65,536 rows. That makes 16,777,216 cells. … Since Excel 2007 the maximum number of rows per worksheet is now 1,048,576 and the number of columns is 16,384. That makes 17,179,869,184 cells.
A worksheet is an arrangement of rows and columns, making up cells into which various types of data and formulas can be entered. Each row is numbered. Each column is headed… by a letter or combination of letters. A number of worksheets are contained in what is called a workbook.
348, at my count
In Excel 2007 the number of rows per worksheet is 1,048,576 and thenumber of columns is 16,384 which is column XFD. That makes17,179,869,184 cells.
There are 16,384 columns (A - XFD) and 1,048,576 rows, for a total of 17,179,869,184 cells per worksheet in Excel 2007.
In early version of the program there was just one. More recently there are now 3 worksheets in a workbook. You can add as many worksheets as your computer can have enough mem…ory for.
I suppose the current worksheet would be the one you currently are working on. It is the active worksheet.
more than 1000. you can add as much sheets you want
Save a copy.
In general, a new workbook in Microsoft Excel starts with three (3) worksheets. The number of worksheets that are created by default may be changed using the Microsoft Excel o…ptions.
By default three, but you can add as required.
16,777,216 cells in Excel 2003 and earlier.17,179,869,184 cells in Excel 2007.
256 columns up to version 2003 and 16384 columns from Excel 2007 onwards.