increase the number of rows or columns in a worksheet, Computer Engineering

How can I increase the number of rows or columns in a worksheet?

Ans) In Excel, each workbook has 255 columns and 65,526 rows. These values are fixed and cannot be changed. If you require more rows, you might require considering using a database (such as Access) or one more spreadsheet (Quattro Pro can handle a million rows) for data storage. In most cases, you probably don't require to work with all of your data at once. You'll usually require only a subset of your data. You can use Excel's Data, Get External Data command to query the database and bring in only the records you require.         

 

 

Posted Date: 4/4/2013 2:04:54 AM | Location : United States







Related Discussions:- increase the number of rows or columns in a worksheet, Assignment Help, Ask Question on increase the number of rows or columns in a worksheet, Get Answer, Expert's Help, increase the number of rows or columns in a worksheet Discussions

Write discussion on increase the number of rows or columns in a worksheet
Your posts are moderated
Related Questions
Question 1: (a) How would you explain human reasoning? (b) Explain the different types of human reasoning? Question 2: (a) What are the computational factors affec

All AWT event listeners expand the java.util.EventListener interface.

what is initial interval and latency in a functional unit(fp) of a pipeline

how create database design for pharmacy by diagram and query

Backward Chaining: In generally given that we are only interested in constructing the path whether we can set our initial state to be the theorem statement and search backward

What are conditional chain statement? ON CHAIN-INPUT similar to ON INPUT. The ABAP/4 module is called if any one of the fields in the chain having a value other than its in

The Set Book assignment should enable you to begin talking about the usability of interactive products in terms of a variety of parameters. Instead of simply saying 'nice cell phon

Name the two operations of stack A stack has only two operations and they are insertion and deletion of items. The operation insertion is called push (or push-down) as it can b

Three firm capabilities that are critical for superior firm performance in e-commerce are:- 1.  Information technology capability,  2.  Strategic flexibility, and  3.  Tr

I want to know...if there is a program available in C code using data structure for online movie booking system