From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- .../source/text/scalc/guide/table_rotate.xhp | 67 ++++++++++++++++++++++ 1 file changed, 67 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/table_rotate.xhp (limited to 'helpcontent2/source/text/scalc/guide/table_rotate.xhp') diff --git a/helpcontent2/source/text/scalc/guide/table_rotate.xhp b/helpcontent2/source/text/scalc/guide/table_rotate.xhp new file mode 100644 index 000000000..2593105f7 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/table_rotate.xhp @@ -0,0 +1,67 @@ + + + + + + + + +Rotating Tables (Transposing) +/text/scalc/guide/table_rotate.xhp + + +Sun Microsystems, Inc. + + + +tables; transposing +transposing tables +inverting tables +swapping tables +columns; swap with rows +rows; swapping with columns +tables; rotating +rotating; tables + +Rotating Tables (Transposing) + +In $[officename] Calc, there is a way to "rotate" a spreadsheet so that rows become columns and columns become rows. + + +Select the cell range that you want to transpose. + + +Choose Edit - Cut. + + +Click the cell that is to be the top left cell in the result. + + +Choose Edit - Paste Special. + + +In the dialog, mark Paste all and Transpose. +If you now click OK the columns and rows are transposed. + + +
+Paste Special +
+ + -- cgit v1.2.3