Search this site
Skip to main content
Skip to navigation
anvilsoup
Home
Systems Engineering
DOORS Next and Jazz
Rational DOORS, DXL, RMF, Macros, and other handy hints
Requirements Engineering
Downloads
ATEM Global Hotkeys
Isodate
OpenLP and OBS Integration
Powerpoint remote presenter fix
Reset Display Settings
Reset Presenter Configuration
Reset Sound Settings
Sidebar Begone: A Google Slides Fix
SqueezyTalk
TimerBot
Excel
Excel: 2016 Macros in 2010
Excel: Add notes to a range of cells
Excel: Adding Vertical Cell Margins
Excel: Auto tool tips
Excel: Finding broken links
Excel: Cell Splitter
Excel: Check background colour
Excel: Compare Columns
Excel: Combine all sheets into one
Excel: Concatenateif
Excel: Convert to Hierarchy or Pivot Diagram
Excel: Create a TOC linked to a Word Doc
Excel: DTG Converter
Excel: Enable Sharing
Excel: Finding the nth last item
Excel: Format sheet based on first column
Excel: Find and Replace
Excel: Fix Names
Excel: Formulas to absolute references
Excel: Get a sheet ready for the customer
Excel: Hide or unhide columns
Excel: Hyperlinking
Excel: Indent macros
Excel: Inherit based on Grouping Levels
Excel: Joining Tables
Excel: Join with Headers
Excel: Merging blank cells
Excel: Multidrop selections
Excel: NMEA Checksum
Excel: Paste to visible cells
Excel: Pivot Tables Edit Row
Excel: Pivot Tables Formatting
Excel: Pivot Tables into static tables
Excel: Pivot Tables Sorting
Excel: Pivot Tables: Text in the Values
Excel: Print all charts
Excel: Protect formula without using data protection
Excel: Record your location and return to it
Excel: Relative references
Excel: Removing all styles
Excel: Returning a value from a matrix
Excel: Sheet Protection
Excel: Show Ancestors
Excel: Subtotal macro
Excel: Summarise
Excel: SuperVlookup
Excel: UniqueInCell UniqueInString
Excel: Unmerge Cells
Excel: Update Formatting
Excel: Views
Excel: vlookup tips
Excel: Power Query Tips
Excel: Extract Comments
Excel: Simple Task Tracker
Excel: Moving rows and columns
Excel: Function Bible
Excel: Change cell in all spreadsheets
Excel: Searching a cell for keywords
Family Stuff
Contraction Timer
Twins on Board
Geek Stuff
Linux File Size
Linux hacks
Microsoft Project
Outlook macros
Linux NTP Server and Router
Information Security
NIST Cybersecurity Framework
SELinux
SSL Certificates
Maths Stuff
Birthday Paradox
Logarithm Tables
Flipper Flapper
Multimedia
Black and White web pages
Compressing Videos
DVD region free in Windows 7
Extracting images from web pages
Gimp Whiteboard Script
Lossless Video Manipulation
Renaming Photos using ExifTool
Turning audio to video
VLC Secondary Display
PDF Manipulation
Adobe Customisation Wizard
Black and White PDFs
Combining PDFs
Converting PDFs to Visio
Optimising PDFs
Removing Content Restrictions from PDFs
Networking
Cisco Lab Config
Cisco stuff
Ether Ape installation
HRPing
IP address script
Network Emulation
Serial Com Port Redirection
Setting up a PXE Server
Subnet Mask Cheat Sheet
Traffic Generation - Multicast
Music
CleanSpeech Audacity chain
DVD Centre Channel fix
Embed Itunes AlbumArt
Guitar Chord Maker (font)
Optical Music Recognition
Pachebel's Canon in D
Piano Tuning
Resizing Music Scores
Recipes
Microwave Chee Cheong Farn
Windows
Accessing Sharepoint using Explorer
Backing up and restoring a computer with Pointsec
Batch Files
Bluetooth Mice
Checking that Group Policies are being applied
Common Command Lines
Disabling Windows web search
Emailing an AD Group
Finding Windows Drivers
Hyper-V Enhanced Session Mode
Keyboard Shortcuts for Moving Windows
LGPO
Making the Power Button Work
Moving pagefile.sys
Multiple NICs
Network Time Protocol
Powershell
Printing folder details
Applocker
Remote Desktop Connections
Resetting Windows Passwords
Resolve 0x00000007B Blue Screen when changing hardware
Windows Backup
Windows Firewall
Windows Hacks
Windows Permissions Reset
Windows Services
Windows Startup and Shutdown analysis
Windows Updates
Windows: Windows Installer freezing
Word
Word: Batch Convert Doc to PDF
Word: Blackline and PDF
Word: Bookmark Utility
Word: Convert number to heading cross-reference
Word: Converting a Master Document into a normal document
Word: Converting Markups to formatted text
Word: Copy Doc Properties
Word: Copy Page Styles
Word: Deleting all headers and footers
Word: Direct Format text
Word: Exporting Comments to Excel
Word: Extract Embedded PDFs
Word: Extracting headings and heading bookmarks
Word: Fix numbered items
Word: Hiding the Document Information Panel automatically
Word: Insert Next Field Reference
Word: Linking and unlinking all headers and footers
Word: Removing protection
Word: Ribbon
Word: Some formatting macros
Word: Styles - Changing Document Template
Word: Styles - Cleaning up
Word: Turning a Word Table into Excel
Word: Track Changes Formatting Hacks
Writings
7 Habits of Highly Effective People
Biology
Economics
Engineering Studies Teachers and Students Guide
English
Exegetical Fallacies by D.A. Carson
Geology
History
Ancient Civilisations
Space
anvilsoup
hyperlinking to particular requirements
=HYPERLINK("#"&CELL("address",INDEX(namedrange,MATCH("SS-008",namedrange,0))),"SS-008")
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse