--- title: "How to change a value across an entire document column at once in 1C" country: KZ lang: en author: Сапа Т.И. (https://buhgpt.kz/authors/sapa-ti) date: 2026-09-23 canonical: https://buhgpt.kz/suraqtar/kak-izmenit-znachenie-srazu-vo-vsem-stolbce-dokumenta-v-1-en source: BuhGPT --- # How to change a value across an entire document column at once in 1C > **TL;DR:** To avoid editing each row of a document's tabular section manually, you can change the value of an entire column with a single action — using the "Change selected" command. This is a standard mechanism of 1C:Accounting for Kazakhstan: you select the required rows or column, in --- To avoid editing each row of a document's tabular section manually, you can change the value of an entire column with a single action — using the "Change selected" command. This is a standard mechanism of 1C:Accounting for Kazakhstan: you select the required rows or column, invoke the command, and set a single value for all selected rows at once. How to do it Select the required column (or rows) in the document's tabular section, right-click, and in the context menu that opens, choose "Change selected". This lets you set a single value for all selected rows at once, without filling them in individually. Step-by-step procedure - Open the document and go to its tabular section (for example, "Goods", "Services", "Materials"). - Select the rows in which you need to change the value. To select several consecutive rows, hold down the Shift key; to select rows selectively — hold Ctrl and click on the required ones. To select the entire tabular section, you can press Ctrl+A while in the list of rows. - Right-click the selected rows and choose "Change selected" in the context menu. - In the window that opens, specify the attribute (column) whose value you need to change — for example, the VAT rate, warehouse, item group, accounting account, unit of measure. - Set the new attribute value and confirm the change. - Check the result: the value should apply to all selected rows. In which documents it is convenient to use The technique works the same in most documents with a tabular section, where the same value is repeated across many rows. The command is most often needed when: - you need to set the same warehouse or department in all rows; - a single VAT rate is required across the entire tabular section of a sales or receipt document; - you need to set the same accounting account, cost item, or item group; - a single unit of measure or one price type is specified for all items. The set of attributes that can be changed depends on the specific document and its tabular section: the system will offer a choice from the columns available in that table. Why this is more convenient than manual entry - Time savings. With dozens and hundreds of rows, manually filling in each cell takes a lot of time and is tiring. - Fewer errors. A single value is entered the same way in all rows, so typos and inconsistency across the column are eliminated. - Uniformity of accounting. The same accounting accounts, warehouses, and rates across the entire tabular section reduce the risk of incorrect reflection in postings and reporting. What to pay attention to - The command will change the value only in the selected rows. If you do not select all rows, some data will remain unchanged — before confirming, make sure the required range is selected. - After a bulk change, some related indicators (for example, VAT amounts, document totals) may require recalculation. Check that the document's total amounts have been updated correctly. - If some rows should keep a different value, do not select them — either first make the bulk change and then correct individual rows manually. - Changing an attribute in a posted document may require reposting so that the new data gets into the registers and postings. - The appearance of the context menu and the set of attributes available for change may differ depending on the configuration version and interface settings. Common mistakes - Selected the wrong rows. The value was applied in bulk to unnecessary items. If this happens, undo the action or manually restore the required values before reposting the document. - Forgot to repost the document. The data in the tabular section has been changed, but the postings and registers remained with the old values. - Did not check totals and VAT. After changing the VAT rate or price, the document's total amounts were not reconciled with the source data. - Changed the wrong attribute. In the "Change selected" window, a column with a similar name was selected — before confirming, check that you are changing exactly the required attribute. What to check - Whether all the required rows were selected before invoking the command. - Whether the attribute (column) was chosen correctly and the new value was entered. - Whether the document totals and VAT amounts were recalculated after the change. - Whether the document was posted (reposted) so that the changes are reflected in accounting. - Whether the accounting accounts, warehouse, and rates match the source documents' data and the organization's accounting policy. The "Change selected" command is a simple and safe way to speed up filling in tabular sections in 1C:Accounting for Kazakhstan. The main thing is to carefully select rows, check the chosen attribute, and after a bulk edit, monitor the totals and the correctness of document posting. --- _BuhGPT — ИИ-помощник для бухгалтеров Казахстана: https://buhgpt.kz_