Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Too Many Rows (MS WORKS)

20 Mar 2016   #1
DickH

Windows 7 64 bit
 
 
Too Many Rows (MS WORKS)

When I copy 6 or 7 rows of data and attempt to paste it into a Works spreadsheet I get this error message.
"There are too many rows. Works does not allow more than 16,384 rows." It will only put in about 4 rows of data.
How can I get rid of the error message?


My System SpecsSystem Spec
.
27 Mar 2016   #2
DickH

Windows 7 64 bit
 
 

With 152 views and no one knows the answer? It's hard to believe.
My System SpecsSystem Spec
27 Mar 2016   #3
Callender

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

Well I haven't used MS Works in a long time but I can take a guess.

When you've selected multiple rows to be copied right click a place in the margin where you want to start pasting and then paste.
Too Many Rows (MS WORKS)-msworks.jpg
That's the way most spreadsheet software works anyway!


My System SpecsSystem Spec
.

27 Mar 2016   #4
whs
Microsoft MVP

Vista, Windows7, Mint Mate, Zorin, Windows 8
 
 

Unfortunately I cannot help you. I was only amazed that somebody is still using Works. I wish you lots of luck in resolving the problem.
My System SpecsSystem Spec
28 Mar 2016   #5
GEWB

Linux (Mint is primary) / XP, Win7 Home / Win7 Pro, Ultimate / Win8.1 / Win10 archived VM
 
 

I think Callender is on track.

Perhaps your spread sheet has the max number of rows as a default thus you cannot add more. You couldm try going own to the last row you hav in use, drop down a dozen rows then select all rows down to the en d and delete the rows (not just the empty content of the rows).

You should then be able to paste in new rows, not just the contents of the rows.

Regards,
GEWB
My System SpecsSystem Spec
28 Mar 2016   #6
DickH

Windows 7 64 bit
 
 

Quote   Quote: Originally Posted by GEWB View Post
I think Callender is on track.

Perhaps your spread sheet has the max number of rows as a default thus you cannot add more. You couldm try going own to the last row you hav in use, drop down a dozen rows then select all rows down to the en d and delete the rows (not just the empty content of the rows).

You should then be able to paste in new rows, not just the contents of the rows.

Regards,
GEWB
Thanks. That sounds good.
My System SpecsSystem Spec
28 Mar 2016   #7
DickH

Windows 7 64 bit
 
 

Quote   Quote: Originally Posted by whs View Post
Unfortunately I cannot help you. I was only amazed that somebody is still using Works. I wish you lots of luck in resolving the problem.
Works came on my Windows 7 PC. It "works" for me.
My System SpecsSystem Spec
28 Mar 2016   #8
DickH

Windows 7 64 bit
 
 

Quote   Quote: Originally Posted by Callender View Post
Well I haven't used MS Works in a long time but I can take a guess.

When you've selected multiple rows to be copied right click a place in the margin where you want to start pasting and then paste.
Attachment 384205
That's the way most spreadsheet software works anyway!
You can't Paste in 1, only A1.
My System SpecsSystem Spec
Reply

 Too Many Rows (MS WORKS)




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
WMC:- How do I increase # of rows in the EPG?
The standard 7-row WMC EPG on my Windows 7 64-bit system wastes a lot of screen space I want to increase number of rows to 9, 10 or 11 I've seen instructions for doing this on a couple of sites, but the reader comments indicate a high failure rate Can anyone point me to reliable instructions...
Media Center
Excel: Combining Rows Based on An Equal Value in One Column
I have attached two images of an Excel worksheet. I have gone to the trouble of taking multiple sets of three columns of associated data, that is data of x, y, z where y and z are associated with x. In building a new table with six sets of data, I put x1, x2, ..., x6 in a single column, and then...
Microsoft Office
Re: EXCEL- resorting rows so they each relate to original rows
Hi, I couldn't find an answer in the Forums for this in the past half hour of looking through them- there are so many, and I need an answer sooner than in the 4 or 5 days it will take me to get through them in HOPES of finding my answer. Sorry. So could someone who knows Excel in Windows 7...
Microsoft Office
Excell 2003 losing rows
I have a large 4000 x 25 Excell 2003 spreadsheet that keeps losing rows of data. I normally add 5-10 rows a day and over the last few weeks I have noticed that a couple of days data has disappeared every so often. The sheet is being closed cleanly and saved. Fortunately I have a daily backup so...
Microsoft Office
Notification Area - spaces between icons? - more rows?
Hi there and welcome, I am new to this forum and I am new to 7. I knew that that's gonna bugs me prior to win7 installation, but due to problems with vista I decided to upgrade to better(?) 7. Now in vista I had 3 rows in tray, now in 7 I have only two rows. When I was checking 7 out as in...
Customization
Toolbars - Number of rows - How to control?
I make my taskbar two rows high, and I made a toolbar named "Progs" containing several folders that contain program shortcuts. The toolbar is making poor use of the vertical space available to it, using only two rows of folders, with the bottom third of it going completely unused. The 2nd row of...
Customization


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:17.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App