[Closed] Resize selected rows and columns only?

Discuss the spreadsheet application

[Closed] Resize selected rows and columns only?

Postby Deblk » Sun Aug 13, 2017 9:48 am

Hiya. how can I resize certain columns and rows without effecting the cells that are already in use? I have tried freezing the cells I do not want changed but that does not work. I have also selected an area to change but that does not work either.
Can anybody help please?
Last edited by Deblk on Tue Aug 15, 2017 6:34 pm, edited 1 time in total.
Libreoffice 5.3.3.2 on Windows 10
User avatar
Deblk
 
Posts: 25
Joined: Tue Aug 08, 2017 10:24 am

Re: Resize selected rows and columns only?

Postby Zizi64 » Sun Aug 13, 2017 10:18 am

What you meant as "resize"? Do yo meant to change the width and/or height of the the cell?

You can resize the width of a whole column only, and you can change the height of a whole row only, but you can not midify the size of an individual cell.

Select a whole row or a whole column, and drag the size, or adjust the numeric value in the menu item
- Format - Row - Height
- Format - Column - Width
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.6 on Win7x64Prof.
And the portable versions: LO3.3.0-LO5.4.1 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5888
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Resize selected rows and columns only?

Postby Deblk » Mon Aug 14, 2017 8:26 am

Zizi64 wrote:What you meant as "resize"? Do yo meant to change the width and/or height of the the cell?

You can resize the width of a whole column only, and you can change the height of a whole row only, but you can not midify the size of an individual cell.

Select a whole row or a whole column, and drag the size, or adjust the numeric value in the menu item
- Format - Row - Height
- Format - Column - Width

I have an area which I do not want to change but would like to have another area where I can change rows and column sizes without effecting the other area if you get my meaning? As I said I did try freezing the area I dont want effected but it did not work :(
Libreoffice 5.3.3.2 on Windows 10
User avatar
Deblk
 
Posts: 25
Joined: Tue Aug 08, 2017 10:24 am

Re: Resize selected rows and columns only?

Postby Zizi64 » Mon Aug 14, 2017 8:57 am

I have an area which I do not want to change but would like to have another area where I can change rows and column sizes without effecting the other area if you get my meaning?

What area? Please definite precisely the area by name or by reference.

Or please upload a sample file here, and colorize the area that yout want to change.


You can resize the width of the area B3:C4 together the size of the cells B1, C1, B2, C2, B5, C5, B6, C6 (and more)... in these columns or
you can resize the height of the area B3:C4 together the size of the cells A3, A4, D3, D4, E3, E4 (and more)... in these rows.

resize cells.png
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.6 on Win7x64Prof.
And the portable versions: LO3.3.0-LO5.4.1 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5888
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Resize selected rows and columns only?

Postby Bill » Mon Aug 14, 2017 9:27 am

When Window > Freeze is selected, the position of the rows above the active cell and the position of the columns to the left of the active cell become frozen on the screen and those rows and columns will not move when scrolling. Freeze has nothing to do with the size of a cell or area.

There is no option to set the size of a specific cell. There are only options to resize selected rows and columns. If a cell is in a selected row or column that is resized, then that cell will always be resized.
AOO 4.1.3 on 64-bit Windows 10 and Antergos Linux
Bill
Volunteer
 
Posts: 6293
Joined: Sat Nov 24, 2007 6:48 am

Re: Resize selected rows and columns only?

Postby Deblk » Mon Aug 14, 2017 10:18 am

Bill wrote:When Window > Freeze is selected, the position of the rows above the active cell and the position of the columns to the left of the active cell become frozen on the screen and those rows and columns will not move when scrolling. Freeze has nothing to do with the size of a cell or area.

There is no option to set the size of a specific cell. There are only options to resize selected rows and columns. If a cell is in a selected row or column that is resized, then that cell will always be resized.

That sounds what I would like to do. I select rows and columns that I want to change the size away from my other work on the sheet but when I do it resizes that as well?
Libreoffice 5.3.3.2 on Windows 10
User avatar
Deblk
 
Posts: 25
Joined: Tue Aug 08, 2017 10:24 am

Re: Resize selected rows and columns only?

Postby Zizi64 » Mon Aug 14, 2017 10:27 am

I select rows and columns that I want to change the size away from my other work on the sheet but when I do it resizes that as well?


Yes you will resize ALL of the cells in the selected row/s/ and/or in the selected column/s/.

No way to resize one selected cell only.
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.6 on Win7x64Prof.
And the portable versions: LO3.3.0-LO5.4.1 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5888
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 35 guests