Excel workbooks guides

Choose a excel workbooks task to see the steps and what to check afterwards.

Create a named range in ExcelCreate a named range in Excel with Jetformat. Use an explicit worksheet reference for the new name.
Append a row to an Excel worksheetAppend a row to an Excel worksheet with Jetformat. This adds a row at the end of a worksheet.
Add an empty worksheet to ExcelAdd an empty worksheet to Excel with Jetformat. Supply a new worksheet name that is distinct from existing sheet names.
Change an Excel column widthChange an Excel column width with Jetformat. Width is measured in character units, not pixels.
Add a comment to an Excel cellAdd a comment to an Excel cell with Jetformat. Attach feedback to an exact sheet and cell address.
Read comments from an Excel worksheetRead comments from an Excel worksheet with Jetformat. Pass --sheet to focus on one sheet, or omit it to read comments from visible worksheets.
Copy a worksheet inside an Excel workbookCopy a worksheet inside an Excel workbook with Jetformat. Copy a visible worksheet and give the copy a new name.
Extract embedded images from ExcelExtract embedded images from Excel with Jetformat. This extracts workbook picture assets.
Add an AutoFilter range to ExcelAdd an AutoFilter range to Excel with Jetformat. An AutoFilter marks a range for filtering in a spreadsheet viewer.
Freeze the first row or column in ExcelFreeze the first row or column in Excel with Jetformat. Choose --row, --col, or both.
Read an Excel cell value and formulaRead an Excel cell value and formula with Jetformat. Use the exact worksheet name and a cell address such as B12.
Set an Excel worksheet header and footerSet an Excel worksheet header and footer with Jetformat. This command reads or writes centered header and footer text.
Hide a column in an Excel worksheetHide a column in an Excel worksheet with Jetformat. Hiding changes display rather than deleting cell data.
Hide a row in an Excel worksheetHide a row in an Excel worksheet with Jetformat. Use a 1-based row number.
Add a hyperlink to an Excel cellAdd a hyperlink to an Excel cell with Jetformat. Supply a cell address and full URL.
Insert a blank row before an Excel rowInsert a blank row before an Excel row with Jetformat. The row number is 1-based and refers to the existing row that should move down.
Inspect Excel sheets, ranges, and formulasInspect Excel sheets, ranges, and formulas with Jetformat. Use structural inspection before selecting a worksheet or editing cells.
Merge visible sheets from Excel workbooksMerge visible sheets from Excel workbooks with Jetformat. Inputs are processed in argument order.
Merge a range of Excel cellsMerge a range of Excel cells with Jetformat. Select a rectangular range such as A1:B1.
List named ranges in an Excel workbookList named ranges in an Excel workbook with Jetformat. Named ranges make formulas readable but can point somewhere unexpected after workbook edits.
Set an Excel worksheet print areaSet an Excel worksheet print area with Jetformat. Choose the cell range intended for printing.
Protect Excel workbook structureProtect Excel workbook structure with Jetformat. Workbook protection restricts structural changes in supporting viewers.
Protect an Excel worksheetProtect an Excel worksheet with Jetformat. Select the worksheet to protect.
Recalculate cached Excel formula valuesRecalculate cached Excel formula values with Jetformat. Workbooks written by libraries may lack formula caches, leaving formula cells blank during conversion.
Delete an Excel column and shift cells leftDelete an Excel column and shift cells left with Jetformat. This removes the named column and changes the positions of following columns.
Delete a named range from ExcelDelete a named range from Excel with Jetformat. Use the exact name reported by excel names.
Delete a visible Excel worksheetDelete a visible Excel worksheet with Jetformat. Confirm the sheet name before writing a new workbook.
Rename a visible Excel worksheetRename a visible Excel worksheet with Jetformat. Use the current sheet name and a distinct replacement.
Write Excel cell values and formulasWrite Excel cell values and formulas with Jetformat. Repeat --set and --set-formula to update multiple cells in one invocation.
Sort an Excel worksheet by a columnSort an Excel worksheet by a column with Jetformat. Choose the sheet, sort column, and direction explicitly.
Split Excel into one workbook per visible sheetSplit Excel into one workbook per visible sheet with Jetformat. Each visible worksheet becomes a separate workbook.
Format an Excel range as a tableFormat an Excel range as a table with Jetformat. The range needs a header and at least one data row.
Convert an XLSX workbook to PDFConvert an XLSX workbook to PDF with Jetformat. Visible worksheets are converted in workbook order into one PDF.
Unhide an Excel columnUnhide an Excel column with Jetformat. Choose the column letter and worksheet name.
Unhide an Excel rowUnhide an Excel row with Jetformat. Choose the existing 1-based row number.
Remove Excel workbook structure protectionRemove Excel workbook structure protection with Jetformat. This removes workbook protection.
Add an Excel drop-down validation listAdd an Excel drop-down validation list with Jetformat. Provide a range and a comma-separated set of allowed choices.