Explain your specific goal in reference to the spreadsheet you attached. Where applicable, the functionality is explained using both the GUI (Graphical User Interface) and macros.
This chapter presents the capabilities of a Calc document that make it suitable as a database tool. I will not help further unless you attach. A Calc document is a very capable database, providing sufficient functionality to satisfy the needs of many users. If you need any additional assistance attach a spreadsheet demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). The text remains on the clipboard as you switch between documents. If, later, you want to add the text in a different document, open the first one, copy the cells of interest to the clipboard, close the first document, then paste into the other document. The text remains on the clipboard so you can paste it dozens of times. To use the macro, select the cell in column A of the row you want to change and execute the macro, either with Tools → Macros → Run Macro or with a keyboard shortcut or a toolbar button.Ī non-macro method for several contiguous cells is to type the text in the first place you want it, copy them to the clipboard, go to other places where you want the text and paste it there. Perhaps assign a keyboard shortcut or create a toolbar buttoon for the macro. (On a Mac hold fn and press ← for the Home key.) Stop recording and give your macro a name. Press the Home key to return to column A. Press right arrow twice to move to column C. After selecting the cell use Tools → Macros → Record Macro. Say you want to add text to columns A and C of the current row. Repetitive tasks I would like to be able to add text to one or more cells in a row at the current cell …
0 kommentar(er)
