*Full list of functions here.
Sharing wizard: Save or email your Workbook with our wizard. Break links, convert to values, delete hidden sheets or comments straight from our wizard.
Email Workbook as Values: Email your current book, removing all formulas and leaving only values; This is done without modifying your current Workbook.
Email Selected Worksheets: You can select which sheets you want to share and attach them to a new email with a single click; This is done without modifying your current workbook.
Export graph to PowerPoint: Automatically export any graph in your worksheet to PowerPoint, in a ready-to-print format.
Error Handling: Automatically wrap errors to blanks or to any custom value.
Round values: Round, round up or round down any number by using our automated round function.
Remove formatting: Remove all formatting from selected cells with a single click.
Short Number Formatting: Format as thousands (K), millions (M), or Billions (B) for better number reading.
E.g. 123456 ➜ $ 123 K
Cases: Quickly change cases for selected text cells to ‘Sentence case’, ‘Upper case’ or ‘Lower case’.
List Formatting: Format cells as a list for easier reading. This is done automatically and without modifying your content.
Spacing: Easily remove spacing errors, leading or trailing spaces, or concatenate text in selected cells.
Insert Check Mark/Cross Mark: Insert these useful symbols with a single click from our tools menu.
Smart Selector: Quickly select cells in your worksheet, based on selected content and/or color.
Watermark: Watermark your worksheet with ‘Confidential’, ‘Sample’, ‘Do Not Copy’ or custom phrases.
Unhide Columns/Rows: Unhide all columns and rows in your worksheet with a single click.
Delete Empty Rows/Columns: Quickly delete empty columns or rows in a selected range.
Delete All Comments: Quickly remove all comments in current worksheet.
Break Links: Remove any connection within your workbook and other data sources.
Delete Empty Sheets: Clean up your workbook by quickly deleting any empty worksheet.
Insert Column/Row: Quicky insert a column or row with these functions.
Autofit Columns/Rows: Make sure you see the full picture by automatically fitting your cells to their content.
Input Format: Work Excel like a Pro; Format input cells the right way so you know which cells should be modified.
Selected Cells to Values: Quickly transform selected range to values, the best way to avoid unpredicted changes to your data.
Go to A1: Forget about endless scrolling to get to the top of your worksheet; Get there, with 100% zoom, in a single click.
Quick Coloring: Use and customize 4 custom fill/text color combos. They work on shapes, graphs and cells.
Darken/Lighten: Make fill color lighter or darker with a single click. Works great with titles and subtitles.
Insert Logo: Upload and have your logo always at hand with our insert logo shortcut.
-10 Custom keyboard shortcuts: Quickly assign any POBS’s function to a keyboard shortcut.
-Easy updating: Updates are easy to do and nonintrusive.
-Multi-language: Currently fully supports English and Spanish.
-Easy on your memory: POBS XL is a less than 10MB download.
-Compatible: Works with any PC running Microsoft® Office 2010 or higher.
ABOUT USCONTACTDOCUMENTATIONLEGAL INFORMATION