Can I create a database in Excel of say a million rows?

Asked By 60 points N/A Posted on -
qa-featured

What is the maximum number of rows and columns in a standard worksheet in Excel? Can I increase the number of rows or columns more than the standard available number? Can I create a database in Excel? If not, what is the option for me to use a database within Excel? What can I do to make this possible?ca

  • Answer Accepted: No
  • Question Category:
SHARE
Answered By 0 points N/A #200190

Can I create a database in Excel of say a million rows?

qa-featured

There are more than 1 lac rows in excel sheet and more than 16,000 columns in it to help the user make it easy and convenient to create vast database. 

The exact number of Rows is 1048576 & columns is 16,384 in an Excel Sheet.  If you want to increase or in need to add more rows or columns you have to switch from standard to MS Excel 2010 version.

How to add rows beyond maximum in an Excel Sheet

 

About Neil Auso
Questions
0
Answers
117
Best Answers
11
  • Posted on -
  • Question Category:

What would be the best time to post content into my blog?

Previous

Which services are recommended to run on a dedicated Ubuntu Server?

Next

Related Questions