Search

Update Cells

Last Updated: Dec 1, 2020

Articles

Use this function to update the specified range of cell(s) with the specified value.

Syntax

Update Cells (update_range, update_value)

Parameters

Input Parameter Name Description
update_range Two cell values (first cell and last cell) separated by ‘:’ to update the range
update_value Value to be updated for the given range

':' is used as separator between the cells.

Sample

Update Cells (A1:G9, test)

  • The cells from ‘A1’ to ‘G9’ are updated with the value ‘test’.

To view all the Excel functions, click here.

Did you find what you were looking for?