Close Help Center ONLYOFFICE Docs Spreadsheet Editor Calendar Creating a recurring event Portal notifications: manageable notifications Assigning a color to your calendar Get a panoramic picture of multitask activities User guides ONLYOFFICE Workspace ONLYOFFICE Groups ONLYOFFICE Docs Mail Server Talk Module ONLYOFFICE Groups Documents Module People Module Commmunity Module CRM Module Projects Module Mail Module Calendar Module ONLYOFFICE Docs Document Editor Program interface Introducing the Document Editor user interface File tab Home tab Insert tab Layout tab References tab Collaboration tab Plugins tab Basic operations Create a new document or open an existing one Copy/paste text passages, undo/redo your actions Change color scheme Page formatting Set page parameters Show/hide nonprinting characters Insert section breaks Insert headers and footers Insert date and time Insert page numbers Insert line numbers Insert footnotes Insert endnotes Convert endnotes and footnotes Add bookmarks Add watermark Paragraph formatting Align your text in a paragraph Set up paragraph outline level Select background color for a paragraph Change paragraph indents Set paragraph line spacing Insert page breaks Add borders Set tab stops Create lists Text formatting Apply formatting presets Set font type, size, and color Apply font decoration styles Copy/clear text formatting Add hyperlinks Insert cross-references Insert a drop cap Operations on objects Insert tables Use formulas in tables Insert images Insert autoshapes Insert charts Insert text objects Add caption Insert symbols Align and arrange objects on a page Change text wrapping Insert content controls Create a Table of Contents Add and Format a Table of Figures Mail Merge Use Mail Merge Math equations Insert equations Document co-editing Collaborative document editing Document Review Compare documents Plugins Edit an image Edit HTML Correct typography Count words Include a video Insert highlighted code Insert references Translate text Extract text from an image Read the text out loud Replace a word by a synonym Upload a document to Wordpress Communicate while editing Tools and settings View document information Save/download/print your document Advanced settings of Document Editor View settings and navigation tools Search and replace function Spell-checking AutoCorrect features Protecting documents with a password Helpful hints About Document Editor Supported formats of electronic documents Keyboard shortcuts Spreadsheet Editor Program interface Introducing the Spreadsheet Editor user interface File tab Home tab Insert tab Layout tab Formula tab Data tab Pivot Table tab Collaboration tab View tab Plugins tab Basic operations Create a new spreadsheet or open an existing one Cut/copy/paste data Undo/redo your actions Operations with sheets Manage sheets Insert headers and footers Cell text formatting Set font type, size, style, and colors Add hyperlinks Clear text, format in a cell Editing cell properties Add borders Align data in cells Merge cells Change number format Editing rows/columns Insert or delete cells, rows, and columns Sort and filter data Use formatted tables Create and edit pivot tables Create slicers for tables Group data Remove duplicates Conditional formatting Data validation Work with functions Insert functions Insert array formulas Use named ranges Operations on objects Insert images Insert charts Insert sparklines Insert and format autoshapes Insert text objects Insert symbols and characters Manipulate objects Math equations Insert equations Spreadsheet co-editing Collaborative spreadsheet editing Manage sheet view presets Plugins Edit an image Include a video Insert highlighted code Translate text Replace a word by a synonym Communicate while editing Tools and settings View file information Save/print/download your spreadsheet Scale a worksheet Advanced settings of Spreadsheet Editor View settings and navigation tools Search and replace functions Spell-checking AutoCorrect features Protecting your spreadsheets with a password Get data from TXT/CSV file Helpful hints About Spreadsheet Editor Supported formats of spreadsheets Keyboard shortcuts Presentation Editor Program interface Introducing the Presentation Editor user interface File Tab Home Tab Insert Tab Collaboration Tab Plugins Tab Basic operations Create a new presentation or open an existing one Copy/paste data, undo/redo your actions Working with slides Manage slides Set slide parameters Apply transitions Insert footers Preview your presentation Text formatting Insert and format your text Add hyperlinks Create lists Copy/clear formatting Operations on objects Insert and format autoshapes Insert and adjust images Insert and edit charts Insert and format tables Insert symbols and characters Fill objects and select colors Manipulate objects on a slide Align and arrange objects on a slide Math equations Insert equations Presentation co-editing Collaborative presentation editing Plugins Edit an image Include a video Insert highlighted code Translate text Replace a word by a synonym Communicate while editing Tools and settings View presentation information Save/print/download your presentation Advanced settings of Presentation Editor View settings and navigation tools Search and Replace Function Spell-checking AutoCorrect features Protecting presentations with a password Helpful hints About Presentation Editor Supported formats of electronic presentations Keyboard shortcuts User Guides about Editors ONLYOFFICE Mobile Apps ONLYOFFICE Documents for iOS ONLYOFFICE Documents for Android ONLYOFFICE Projects for iOS ONLYOFFICE Web Editors Glossary Video FAQ General Technology Pricing Workspace Enterprise Edition Docs Enterprise Edition Docs Developer Edition ONLYOFFICE Groups Connectors Clear text, format in a cell, copy cell format cell formatting Add borders Align data in cells Clear text, format in a cell Merge cells Select cell background color Add cell borders Apply cell style Align data in cells More articles How to split cells How to add cells How to merge cells How to calculate percentages How to insert time Wrap text in a cell Merge cells Change number format Apply table styles Select cell background color Add cell borders Apply cell style Align data in cells Change text orientation Wrap text in a cell Merge cells Change number format Select cell background color Add cell borders Apply cell style Align data in cells Change text orientation Wrap text in a cell Merge cells Change number format Select cell background color Add cell borders Apply cell style Align data in cells Change text orientation Wrap text in a cell Merge cells Change number format How to merge cells Wrapping text clear formatting Clear text, format in a cell Copy/clear formatting Copy/clear text formatting Clear format In the Spreadsheet Editor, you can quickly remove the text or format from the selected cell. To do that, select a cell, a cell range with the mouse or the whole worksheet by pressing the Ctrl+A key combination, Note: you can also select multiple non-adjacent cells or cell ranges holding down the Ctrl key while selecting cells/ranges with the mouse. click the Clear icon on the Home tab of the top toolbar and select one of the available options: use the All option if you wish to remove everything including the text, format, function etc; use the Text option if you wish to remove the text from the selected range of cell range; use the Format option if you wish to remove the format of the selected cell range. The text and all functions will remain; use the Comments option if you wish to remove comments from the selected cell range; use the Hyperlinks option if you wish to remove hyperlinks from the selected cell range. Note: all these options are also available in the right-click menu. Copy cell format You can quickly copy the format of a certain cell and apply it to other cells. To apply the copied format to a single cell or several adjacent cells, select the cell/cell range with the required format by clicking or using the keyboard, click the Copy style icon on the Home tab of the top toolbar, (the mouse pointer will look like this ), select the cell/cell range to apply the required format to. To apply the copied format to multiple non-adjacent cells or cell ranges, select the cell/cell range with the required format by clicking or using the keyboard, double-click the Copy style icon on the Home tab of the top toolbar, (the mouse pointer will look like this and the Copy style icon will remain selected: ), click the required cells or select the cell ranges one by one to apply the same format to all of them, to exit this mode, click the Copy style icon once again or press the Esc key on the keyboard. Return to previous page Try now for free Try and make your decision No need to install anything to see all the features in action